Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro security too high in excel, I can not get into input data | Excel Worksheet Functions | |||
Possible Macro Timing Overrun generates Excel Exception | Excel Discussion (Misc queries) | |||
change default chart settings for new excel charts automatically | Charts and Charting in Excel | |||
Closing File Error | Excel Discussion (Misc queries) | |||
How do I change the columns in excel back to alpha characters? | Setting up and Configuration of Excel |