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.
|