ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro - security levels (https://www.excelbanter.com/excel-discussion-misc-queries/145668-macro-security-levels.html)

Becky

Macro - security levels
 
When clicking on a macro I've created, I'm getting the "macros in this
workbook are disabled because the security level is high..."

how can I fix this problem from occurring?? merely changing the security
level doesn't fix it.

Dave Peterson

Macro - security levels
 
You have to change the security level, then reopen the workbook.

This setting isn't retroactive for already open workbooks.

Becky wrote:

When clicking on a macro I've created, I'm getting the "macros in this
workbook are disabled because the security level is high..."

how can I fix this problem from occurring?? merely changing the security
level doesn't fix it.


--

Dave Peterson

kyoshirou

Macro - security levels
 
Go to Tools -- Macro --Security-- choose medium

"Dave Peterson" wrote:

You have to change the security level, then reopen the workbook.

This setting isn't retroactive for already open workbooks.

Becky wrote:

When clicking on a macro I've created, I'm getting the "macros in this
workbook are disabled because the security level is high..."

how can I fix this problem from occurring?? merely changing the security
level doesn't fix it.


--

Dave Peterson



All times are GMT +1. The time now is 09:44 AM.

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