Inconsistent macro problem in excel

[MarkMcK]

XP was rolled out at my work yesterday. Most of the excel file I work
with have Visual Basic macros coded into them. (I use Excel 2002)

Sometimes, I'll open a file, and it will give me the "Enable Macros?"
prompt. This is normal, and what I want it to do.

Sometimes, I'll open the same file, and it will give me no prompt.
And if I try to run one of the macros, it tells me that the macros are
disabled because the security is set to high. So, I go the macro
security area to check it out...it's on medium, like it always is.

I've found that the only consistent way to ensure that all opened
files prompt me properly is to only have one excel file open at a
time, and if I want to open a different file, I have to close the
first one, then completely shut down excel, then open it back up
again.

I've been told that just setting the security to "low" will take care
of this, but that's not really all that prudent. These are widely
distributed files, so I'm not sure that a digital signature is the
answer either.

Does anyone have any insights?

 

[Dave Peterson]

As a temporary measure, I'd go to Tools|macros|security tab and toggle the
setting to high, then back to medium. Then try opening the workbook.

If that works, then there's something wrong with the way the value is getting
stored (or retrieved) from the registry.

You may want to talk to your IT department to make sure you are authorized to
make (save?) changes in the registry.