View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AlanS AlanS is offline
external usenet poster
 
Posts: 8
Default Macros Disabled in Excel 2007

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
users.

Thanks

--
Alan