ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Security in macro (https://www.excelbanter.com/excel-discussion-misc-queries/14847-security-macro.html)

Pam Coleman

Security in macro
 
I have created a macro and when I try to run it I get a security error and it
says to change my security from high to low. When I go to Tools - Macro -
Security and change it to low, I get the same error when I try to run the
macro. What is wrong?

Dave Peterson

You have to close that workbook and reopen it with the setting changed.

(That setting is not retroactive to workbooks that are currently open.)

Pam Coleman wrote:

I have created a macro and when I try to run it I get a security error and it
says to change my security from high to low. When I go to Tools - Macro -
Security and change it to low, I get the same error when I try to run the
macro. What is wrong?


--

Dave Peterson


All times are GMT +1. The time now is 05:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com