![]() |
Macros/Security
I have created two Macros in worksheet.
When I attempt to run them, I get error message saying Security Level is High. I go to Security Option, check Low, and still get same message. Please advise! Excel 2002 Thanks. -- Jeff |
Macros/Security
Jeff,
Save the file, then close excel, reopen the file and run your macros. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Jeff" wrote: I have created two Macros in worksheet. When I attempt to run them, I get error message saying Security Level is High. I go to Security Option, check Low, and still get same message. Please advise! Excel 2002 Thanks. -- Jeff |
Macros/Security
wtf?
That worked, thank you, but why? -- Jeff "Michael" wrote: Jeff, Save the file, then close excel, reopen the file and run your macros. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Jeff" wrote: I have created two Macros in worksheet. When I attempt to run them, I get error message saying Security Level is High. I go to Security Option, check Low, and still get same message. Please advise! Excel 2002 Thanks. -- Jeff |
Macros/Security
Why?.............because Excel High security had already disabled the macros
when the workbook opened. That's it.................no macros will run after that. Re-setting to Low will not re-enable the macros until the workbook is saved and re-opened and the Low setting is recognized. Gord Dibben MS Excel MVP On Wed, 17 Dec 2008 08:54:08 -0800, Jeff wrote: wtf? That worked, thank you, but why? |
All times are GMT +1. The time now is 02:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com