Restrict Prompting for Macro Security

[Rob]

Hello,

I was wondering if there was a way to make it to where no one is prompted to
"Enable" or "Disable" Macros to the Workbook - Except if the user is only Me.

The sitch is that I have macros in my workbook and when it's opened ppl are
being prompted to enable them or disable them. I was looking for a way that
makes it to whaere only I am able to access/enable the macros and have
everyone else not even be able to have the choice. This way the macros are
inactive and unusable to everyone except for me.

Thanks in Advance.
Rob

 

[Bob Phillips]

Set their macro security level to High.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Tim]

Rob,

I think that is kind of the whole point of the message! i could be wrong,
but if you could suppress that message, i'm sure it would be a security
risk. I think you can get around it using certification, but that just
creates a different set of problems if you're trying to distribute the
spreadsheet (which is what i think you are trying to do).

If someone knows otherwise, i'd be interested to know how!

Tim

 

[Tim]

Sorry - i completely mis-read your question... i thought you were trying to
get people to run the macros. don't listen to me, listen to Bob!

 

[Rob]

Hello,

I was wondering if there was a way to make it to where no one is prompted to
"Enable" or "Disable" Macros to the Workbook - Except if the user is only Me.

The sitch is that I have macros in my workbook and when it's opened ppl are
being prompted to enable them or disable them. I was looking for a way that
makes it to whaere only I am able to access/enable the macros and have
everyone else not even be able to have the choice. This way the macros are
inactive and unusable to everyone except for me.

Thanks in Advance.
Rob

Are the other users opening the book read only? If so you could have
code identify the user and then if it is not you delete all of the
code from the workbook. The user will still get the prompt but will
not be able to see your code.

 

[Barb Reinhardt]

That's kinda scary to me. I think I'd try putting something in the
Workbook_Open to check for the user name and if it's not the OP, set the
Public AUtoSec as MSOAutomationSecurity

AutoSec = application.AutomationSecurity
Application.AutomationSecurity = msoAutomationSecurityForceDisable

In the Workbook_Close event, I'd reset

Application.AutomationSecurity = AutoSec

 

[Rob]

Thank You that does the trick. And yes I should have clarified that I simply
do not want people to be able to alter the code so I'd like them to not have
to worry about being prompted over and over again when they open it.