Excel - Macros Disabled in Excel 2007

Asked By Alan on 17-Jul-08 01:48 PM
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




Jim Rech replied on 17-Jul-08 02:12 PM
Might be this issue if the workbook has a password:

http://www.rondebruin.nl/password2007.htm

--
Jim
workbook,
excel
Alan replied on 17-Jul-08 02:41 PM
It does since it contains payroll information.  I guess I will just have to
have them remove the password, save the file, then reopen the file and print
from the macro, then resave the file with the password put back in.

I don't think I want these people trying to go into regedit.

Thanks for your help.  It definately explains the problem but it makes files
that have macros and passwords really inconvenient to work with for the
average user.
--
Alan
Jim Rech replied on 17-Jul-08 04:40 PM
Ron does provide this REG file so Regedit doesn't have to be used.  Just
double-click it.

http://www.rondebruin.nl/files/PassWord.reg

But, I know, this might not fly in a corporate environment.

--
Jim
to
print
files
through a
settings,
that
it
Publishers"