| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro Prompting | Excel Programming | |||
| Macro Examples for prompting info | Excel Programming | |||
| Save file without prompting in Excel Macro | Excel Programming | |||
| Excel Macro Save CSV Cell without Prompting | Excel Discussion (Misc queries) | |||
| Prompting 'Save As' in an Excel Macro | Excel Programming | |||
Linear Mode
