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
"AlanS" wrote in message
...
| 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" wrote:
|
| Might be this issue if the workbook has a password:
|
| http://www.rondebruin.nl/password2007.htm
|
| --
| Jim
| "AlanS" wrote in message
| ...
| |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
|
|
|