Without code the only way is to save the workbook with that particular sheet
active.

A workaround is to add before_close code that renders the workbook unusable if
users open without enabling macros.

This would consist of code that hides all the sheets except a message sheet that
says "You have disabled macros. Close then re-open this workbook with macros
enabled or go home for the day since you have nothing to do!"


Gord Dibben MS Excel MVP


On Thu, 7 Dec 2006 09:47:00 -0800, sdhaight
wrote:

Hello,

I have read some of your postings and found the macro below to open the file
on a specific worksheet but I'm wondering if there's a function besides a
macro for doing this. My concern is that our file will be used by 100
different users on different versions of Excel so I'm not sure it will work
consistently. Also, unless macro security is set to low, the user will be
promted to enable the macro and it won't work if they say no. Any other
options?

Private Sub Workbook_Open()
Worksheets("Sheet1").Activate
End Sub

Thanks so much,
Sherry