View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Restrict Prompting for Macro Security

Set their macro security level to High.

--
HTH

Bob

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

"Rob" wrote in message
...
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