Restrict Prompting for Macro Security
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.
|