Macro Security Setting not applying

[Guest]

Help!

I have a workbook that will sporadically lose it's ability to run macros
even though the macro security setting is set to 'medium'. i.e. - no message
box comes up when opening the file and when trying to run any macros, the
"cannot run macros ..." box comes up.

The only way I can fix this is to open the file, select macro-security
setting "low", save the file, open it again, and then return the setting to
"medium".

This file is out on a shared drive and many of my users need to access this
- so the quick-fix noted above really isn't sufficient.

Has anybody else seen this happen and have a fix for it??

Thanks!!

Andrew Chaves

 

[Dave Peterson]

You have one reply in .misc

Help!

I have a workbook that will sporadically lose it's ability to run macros
even though the macro security setting is set to 'medium'. i.e. - no message
box comes up when opening the file and when trying to run any macros, the
"cannot run macros ..." box comes up.

The only way I can fix this is to open the file, select macro-security
setting "low", save the file, open it again, and then return the setting to
"medium".

This file is out on a shared drive and many of my users need to access this
- so the quick-fix noted above really isn't sufficient.

Has anybody else seen this happen and have a fix for it??

Thanks!!

Andrew Chaves