Macros Disabled in Excel 2007

[AlanS]

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

 

[Jim Rech]

Might be this issue if the workbook has a password:

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

--
Jim
|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

 

[AlanS]

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.

 

[Jim Rech]

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