software

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 -

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

quot;john mcmichaelquot; gt; wrote in message
...
gt;I would like to set Excel 2003 macro settings to High, however, every time
gt;I
gt; do this save and close the file and reopen it, it changes back to low.
gt; Can I
gt; set it to High by default so that it stays that way?
gt;
gt; Thanks.
gt;
gt; Have a great day
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.

quot;Mike Middletonquot; wrote:

gt; john mcmichael -
gt;
gt; Maybe it's not a file setting. Maybe it's an application (Excel) setting.
gt; Try this: change to High, close Excel, and restart Excel.
gt;
gt; - Mike
gt; www.mikemiddleton.com
gt;
gt; quot;john mcmichaelquot; gt; wrote in message
gt; ...
gt; gt;I would like to set Excel 2003 macro settings to High, however, every time
gt; gt;I
gt; gt; do this save and close the file and reopen it, it changes back to low.
gt; gt; Can I
gt; gt; set it to High by default so that it stays that way?
gt; gt;
gt; gt; Thanks.
gt; gt;
gt; gt; Have a great day
gt;
gt;
gt;

john -

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

Yes, that's what I would expect.

But, what happens if you do what I suggested?

That is, quot;change to High, close Excel, and restart Excel.quot;

- Mike

quot;john mcmichaelquot; gt; wrote in message
...
gt; No luck. When I set security to low and close and reopen, security
gt; defaults
gt; back to low. Any other help would be appreciated. Thanks again in
gt; advance
gt; for your help.
gt;
gt; quot;Mike Middletonquot; wrote:
gt;
gt;gt; john mcmichael -
gt;gt;
gt;gt; Maybe it's not a file setting. Maybe it's an application (Excel) setting.
gt;gt; Try this: change to High, close Excel, and restart Excel.
gt;gt;
gt;gt; - Mike
gt;gt; www.mikemiddleton.com
gt;gt;
gt;gt; quot;john mcmichaelquot; gt; wrote in
gt;gt; message
gt;gt; ...
gt;gt; gt;I would like to set Excel 2003 macro settings to High, however, every
gt;gt; gt;time
gt;gt; gt;I
gt;gt; gt; do this save and close the file and reopen it, it changes back to low.
gt;gt; gt; Can I
gt;gt; gt; set it to High by default so that it stays that way?
gt;gt; gt;
gt;gt; gt; Thanks.
gt;gt; gt;
gt;gt; gt; Have a great day
gt;gt;
gt;gt;
gt;gt;