Ok, I'll bite. Why not use the auto_open or workbook_open events?

Art


On Tuesday, March 3, 2015 at 2:50:29 PM UTC-5, GS wrote:
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