Restrict Prompting for Macro Security
 

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

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

Restrict Prompting for Macro Security
 

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


"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

Restrict Prompting for Macro Security
 

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!


"Tim" <tmarsh-trousers-@-take off my trousers to reply-blueyonder.co.uk
wrote in message ...
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


"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

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.

Restrict Prompting for Macro Security
 

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.

Restrict Prompting for Macro Security
 

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.