Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enable Macros by Code
Is there code I can put in visual basic that will enable all macros when the
workbook opens, so there is no need to click the options for enable macros. I know how to enable macros in the Trust Center, I would like to enable by code. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enable Macros by Code
Try putting this BEFORE you open up your macro.
Application.AutomationSecurity = msoAutomationSecurityLow If you want the user to later be requested to enable macros, change it back to Application.AutomationSecurity = msoAutomationSecurityByUI -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "aftamath77" wrote: Is there code I can put in visual basic that will enable all macros when the workbook opens, so there is no need to click the options for enable macros. I know how to enable macros in the Trust Center, I would like to enable by code. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enable Macros by Code
Hi
There is no way to include such code within a workbook to enable the macros within that same workbook - the enable/disbale macros prompt is for security purposes, so it wouldn't be much use if you could simply override it. Richard "aftamath77" wrote in message ... Is there code I can put in visual basic that will enable all macros when the workbook opens, so there is no need to click the options for enable macros. I know how to enable macros in the Trust Center, I would like to enable by code. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enable Macros by Code
Hi,
No, you can't enable macros by code. If security is set to medium or higher then it's a user choice whether macros are enabled or not. Mike "aftamath77" wrote: Is there code I can put in visual basic that will enable all macros when the workbook opens, so there is no need to click the options for enable macros. I know how to enable macros in the Trust Center, I would like to enable by code. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enable Macros by Code
Create a Digital Signature.
Add Digital Signature to your macros. Add Digital Signature to 'Trusted Sources' to the user's computers. -- John C "aftamath77" wrote: Is there code I can put in visual basic that will enable all macros when the workbook opens, so there is no need to click the options for enable macros. I know how to enable macros in the Trust Center, I would like to enable by code. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable Macros | Excel Discussion (Misc queries) | |||
how to enable macros | Excel Discussion (Misc queries) | |||
Enable Macros | Excel Worksheet Functions | |||
can not enable macros | Excel Worksheet Functions | |||
macros enable | New Users to Excel |