Excel 2007 Macro security problem.

[Guest]

Hi All,

I have several macros (self published) that I have run in Excell 97 all the
way through 2003). These are very basic macros create with the recorder. When
I upgraded to 2007, none of the macros will work. They are blocked with
security warnings. I have verified that I am listed as a trusted publisher.
I have even turned security off, it does not seem to matter, the macros won't
run.

The message states, "...because of your security settings, macros have been
disabled. Please close and then re-open the workbook and choose enable macros"

Enable macros has never appeared in my workbook. (I am using Excel 2007
..XLSM format)

Any idea's?

 

[Incidental]

Hi Andy

not sure if this will help any but when i tried the beta version i
found the same thing though excel was asking me if i wanted to let the
macros run i just didn't see it as it popped up just below the menu
ribbon.

anywho i hope this is of some use to you

S

 

[Guest]

Thanks for the help, but no, there is no bar :-(