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. |
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. |
All times are GMT +1. The time now is 02:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com