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
.
|