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

Hi Nirmal

get rid of this prompt?
The only simple way is that the user have security to low

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Nirmal Singh" wrote in 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

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
.

If you are working in-house and the other members of your team can trust you,
create a digital certificate for yourself -- run "Selfcert.exe" which you
will probably find in C:\Program Files\Microsoft Office\Office.

Once you have created your certificate go into the macro editor and select
Tools/Digital Signature from the menu. Select your certificate and resave
your macro.

When you now send it out for others they will be asked on the first occasion
whether the macro should be enabled but there is also a tick box to enable
them to always trust you. If they select that box they will never be troubled
with that opening dialogue again either with this macro or any other macro
that you sign with the same certificate.