Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to ignore on-screen message concerning "Enable Macros."
I have an auto_open sub for a workbook - is there line of code I could add to have Excel accept "Enable Macros" without displaying the message box? I want to speed through this message box when the Workbook is projected on-screen in a meeting.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to ignore on-screen message concerning "Enable Macros."
Hi
as this is a security setting only setting the security level to 'Low' will prevent this message box (Tools - Macro - Security). Though this is a global setting. You should use this only in this specific scenario -- Regards Frank Kabel Frankfurt, Germany Phil Hageman wrote: I have an auto_open sub for a workbook - is there line of code I could add to have Excel accept "Enable Macros" without displaying the message box? I want to speed through this message box when the Workbook is projected on-screen in a meeting. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to ignore on-screen message concerning "Enable Macros."
Thanks, Frank.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"excel "macros may be disabled" message using an xlam file | Excel Worksheet Functions | |||
Macro "disable or enable" screen | Excel Discussion (Misc queries) | |||
How do I ignore the "Number stored as text" error message permane. | Excel Discussion (Misc queries) | |||
"openinf file..."ENABLE MACROS...DISABLE MACROS" | Excel Discussion (Misc queries) | |||
kill "enable macros" message | Excel Discussion (Misc queries) |