ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Not able to KEEP Macro Security Level At Minimum (https://www.excelbanter.com/excel-discussion-misc-queries/75293-not-able-keep-macro-security-level-minimum.html)

Carl

Not able to KEEP Macro Security Level At Minimum
 
I changed the macro security level to minimum and saved the file in Excel,
then closed Excel. When Excel reopens, the macro security level is back at
medium. Is it possible the IT department has done this or is there something
else I can do? Thanks.

Dave Peterson

Not able to KEEP Macro Security Level At Minimum
 
This setting is kept in the windows registry. So it's very possible that your
IT folks restricted you from changing stuff in the registry.



Carl wrote:

I changed the macro security level to minimum and saved the file in Excel,
then closed Excel. When Excel reopens, the macro security level is back at
medium. Is it possible the IT department has done this or is there something
else I can do? Thanks.


--

Dave Peterson

Ardus Petus

Not able to KEEP Macro Security Level At Minimum
 
You should try closing/reopening Excel after you change security level.
Security level is maintained at app level, not workbook.

HTH
--
AP

"Carl" a écrit dans le message de
...
I changed the macro security level to minimum and saved the file in Excel,
then closed Excel. When Excel reopens, the macro security level is back at
medium. Is it possible the IT department has done this or is there

something
else I can do? Thanks.





All times are GMT +1. The time now is 11:07 PM.

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