Disable Macros

[Alan Dresch]

Is it possible to Disable the Disble prompt when opening a
Workbook with macros.

In other words I want the user to always 'use macros' on
opening - no option.

Thanks

Alan

 

[Bob Phillips]

Not through ode you can't. In XL2002 up, the user can set their security
level to low, but this is not recommended. The other option is digital
signing code, but this may be OTT for your needs.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi alan
this would require to set the security options of your user to 'low'
(in the Menu 'Tools - Macros - Security).
I would not do that as this is a security feature of Excel.

 

[jeff]

Alan ,

If you really want your users to use your macros
rather than just get into the workbooks and muck
around on their own, you could think about hiding
everything and password protecting it, so that only
your macro (like first in Auto_Open) would open
it up and unhide, etc, otherwise they'd just get a blank
workbook.

I'm not sure it that would be recommended or not,
depending on your real need for them to use what
you've set up.

Good luck.