ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   macro security settings excel change back to low (https://www.excelbanter.com/excel-discussion-misc-queries/83624-macro-security-settings-excel-change-back-low.html)

john mcmichael

macro security settings excel change back to low
 
I would like to set Excel 2003 macro settings to High, however, every time I
do this save and close the file and reopen it, it changes back to low. Can I
set it to High by default so that it stays that way?

Thanks.

Have a great day

Mike Middleton

macro security settings excel change back to low
 
john mcmichael -

Maybe it's not a file setting. Maybe it's an application (Excel) setting.
Try this: change to High, close Excel, and restart Excel.

- Mike
www.mikemiddleton.com

"john mcmichael" wrote in message
...
I would like to set Excel 2003 macro settings to High, however, every time
I
do this save and close the file and reopen it, it changes back to low.
Can I
set it to High by default so that it stays that way?

Thanks.

Have a great day




john mcmichael

macro security settings excel change back to low
 
No luck. When I set security to low and close and reopen, security defaults
back to low. Any other help would be appreciated. Thanks again in advance
for your help. :)

"Mike Middleton" wrote:

john mcmichael -

Maybe it's not a file setting. Maybe it's an application (Excel) setting.
Try this: change to High, close Excel, and restart Excel.

- Mike
www.mikemiddleton.com

"john mcmichael" wrote in message
...
I would like to set Excel 2003 macro settings to High, however, every time
I
do this save and close the file and reopen it, it changes back to low.
Can I
set it to High by default so that it stays that way?

Thanks.

Have a great day





Mike Middleton

macro security settings excel change back to low
 
john -

You wrote "When I set security to low and close and reopen, security
defaults back to low."

Yes, that's what I would expect.

But, what happens if you do what I suggested?

That is, "change to High, close Excel, and restart Excel."

- Mike

"john mcmichael" wrote in message
...
No luck. When I set security to low and close and reopen, security
defaults
back to low. Any other help would be appreciated. Thanks again in
advance
for your help. :)

"Mike Middleton" wrote:

john mcmichael -

Maybe it's not a file setting. Maybe it's an application (Excel) setting.
Try this: change to High, close Excel, and restart Excel.

- Mike
www.mikemiddleton.com

"john mcmichael" wrote in
message
...
I would like to set Excel 2003 macro settings to High, however, every
time
I
do this save and close the file and reopen it, it changes back to low.
Can I
set it to High by default so that it stays that way?

Thanks.

Have a great day








All times are GMT +1. The time now is 04:13 PM.

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