ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Macros/Security (https://www.excelbanter.com/excel-worksheet-functions/213996-macros-security.html)

Jeff

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

Michael

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


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


Gord Dibben

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