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.

"Barb Reinhardt" wrote:

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

--
HTH,
Barb Reinhardt



"Rob" wrote:

On Aug 14, 11:23 am, Rob wrote:
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.