I use to be able to set the protection properties to enable macros and
everything with macros would work without halting. Now in 2007 I must save in
..xlsm format for this to happen. I am the only person on my computer and it's
real pain to remember to file as a special format when I have created
macros. Is there way to just allow macros period?
--
Skip
Using Office 2003 Pro
2007 Student version

There is a setting in Office | Excel Options that saves all files as
macro-enabled
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Skip Bisconer" wrote in message
...
I use to be able to set the protection properties to enable macros and
everything with macros would work without halting. Now in 2007 I must save
in
.xlsm format for this to happen. I am the only person on my computer and
it's
real pain to remember to file as a special format when I have created
macros. Is there way to just allow macros period?
--
Skip
Using Office 2003 Pro
2007 Student version