I have converted a file from Excel 2003 to Excel 2007 (SP1).
In the file I have a print macro assigned to a buttom that goes through a
For Next Loop to print some reports from employees.
I try to run the Macro and get a message - "Because of security settings,
macros have been disabled. To run macros, you need to reopen this workbook,
and then choose to enable macros."
I checked the macro setting and it is set ot Enable all macros.
In addition I put the file in a directory on my hard drive and made that
directory a "Trusted Location".
I have read a couple of Excel books and looked at the Excel help and it
seems like that should allow me the run the macro.
Any suggestions? I really don't want to get into the "Trusted Publishers"
and certificates as the people who will use this file are not high end excel