R
Ryan
I just upgraded to 2003 and my security settings are set to medium for
macros. In 2000 everytime I opened this spreadsheet I got the prompt
to enable or disable the macros. This is what I need to happen in
2003 as well. But now, if I open the sheet once and select disable,
the next time I open the sheet they are disabled as well. In order to
get it to "reset" itself I have to close all open Excel sheets. This
is a huge pain as I work with 10 meg files constantly which take 2 to
3 minutes to both open and close, not to mention to save. So I'm
constantly waiting on Excel now that I upgraded.
How can I change this setting so that it shows all the time and
doesn't try to predict what I want it to do? Thanks.
macros. In 2000 everytime I opened this spreadsheet I got the prompt
to enable or disable the macros. This is what I need to happen in
2003 as well. But now, if I open the sheet once and select disable,
the next time I open the sheet they are disabled as well. In order to
get it to "reset" itself I have to close all open Excel sheets. This
is a huge pain as I work with 10 meg files constantly which take 2 to
3 minutes to both open and close, not to mention to save. So I'm
constantly waiting on Excel now that I upgraded.
How can I change this setting so that it shows all the time and
doesn't try to predict what I want it to do? Thanks.