View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default run time error 32809

I'm going to suggest you *do not use* the Workbook_Open event at all,
*ever*. Instead, in a standard module...

Option Explicit
Option Private Module

Sub Auto_Open()
Application.GoTo ThisWorkbook.Sheets("Instructions").Range("A1")
End Sub

...where this is a 'public' scope procedure exclusive to your project.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion