View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Opening a workbook at a specific sheet

hi,
you will have to change the security level of the file.
goto ToolsmacroSecurity...
the options are high, medium or low. set to low the enable
macro box will not pop up.
Consider the full ramifications before deciding.

-----Original Message-----
I have a workbook with various worksheets in it. To

force Excel to
open it at a a specific sheet I use code like this in the

Workbook
Open event:

Sheets("MySheet").Activate

This works, but the users get prompted to accept Macros.

Can I get
rid of this prompt?

Nirmal
.