Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
john mcmichael
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Mike Middleton
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
john mcmichael
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Mike Middleton
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro security too high in excel, I can not get into input data Diane Excel Worksheet Functions 5 April 4th 06 11:51 PM
Possible Macro Timing Overrun generates Excel Exception [email protected] Excel Discussion (Misc queries) 2 February 23rd 06 04:10 PM
change default chart settings for new excel charts automatically Nedwardt Charts and Charting in Excel 0 October 20th 05 08:27 PM
Closing File Error jcliquidtension Excel Discussion (Misc queries) 4 October 20th 05 12:22 PM
How do I change the columns in excel back to alpha characters? Erin D. Setting up and Configuration of Excel 1 January 6th 05 02:00 AM


All times are GMT +1. The time now is 03:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"