Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Enable after Disabled
I have a large spreadsheet with macros. Sometimes when I open this
spreadsheet, the enable/disable dialogue box doesn't appear, and the file is opened w/out enabling the macros. Is there a way to: 1) make sure dialogue box always appears; or 2) enable the macros after the file is already open w/ macros disabled (without closing and reopening the file)? Thanks for the help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Enable after Disabled
1. Set security to medium. When High or Very high, macros are automatically
disabled. 2. Cannot be done without closing then re-opening with macros enabled. If the workbook is just for your own use on your computer, I would suggest creating a digital signature via Office's SelfCert tool. Gord Dibben MS Excel MVP On Fri, 25 Jan 2008 12:37:02 -0800, tj wrote: I have a large spreadsheet with macros. Sometimes when I open this spreadsheet, the enable/disable dialogue box doesn't appear, and the file is opened w/out enabling the macros. Is there a way to: 1) make sure dialogue box always appears; or 2) enable the macros after the file is already open w/ macros disabled (without closing and reopening the file)? Thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort Warning disabled? Need to enable it | Excel Discussion (Misc queries) | |||
merge cells disabled how do I enable | Excel Worksheet Functions | |||
Paste Disabled- how to enable it? | Excel Discussion (Misc queries) | |||
AutoCalculate appears disabled - how enable?? | Excel Discussion (Misc queries) | |||
How do I enable a disabled Autofilter in Excel | Excel Programming |