Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Pop-Up Message
I have my macro security set to Medium and want it to show the Enable/Disable
macro message when I or anyone else opens a worksheet that contains macros. Why does the message not alwyas pop up? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Pop-Up Message
Most obvious reason for not popping up would be that the workbook has no
macros in it. If you've just changed the security setting, you must close Excel and reopen it for the change to become effective. If you're using Excel 2007, there are 'trusted locations' that if your workbook is placed into, macros are always trusted and you get no warnings when opening workbooks from there regardless of your settings. Remember that the security settings do not go with the workbook - they are local to the computer/copy of Excel on the computer. So if you have your security setting on Medium to get the warnings and have a workbook with macros in it and send that to someone using another computer, it is THEIR security settings that rule, and if they have them set at LOW (really unsafe) then they will not get the warning popup. "Millie" wrote: I have my macro security set to Medium and want it to show the Enable/Disable macro message when I or anyone else opens a worksheet that contains macros. Why does the message not alwyas pop up? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro message | Charts and Charting in Excel | |||
Message Box Macro | Excel Discussion (Misc queries) | |||
Message box macro | Excel Discussion (Misc queries) | |||
Macro message | Excel Discussion (Misc queries) | |||
Macro message box | Excel Discussion (Misc queries) |