Macros for Excel 2007
 

I have a macro that works perfectly in earlier versions, but since upgrading
I can't seem to figure out the settings. When I attempt to run the macro, I
get the error
"..that macros have been disabled. To run reopen and choose enable macros."

The macros enable setting is already enabled.
The folder where the spreadsheet resides is set as a Trusted Location
I have set up my personal digital signature. However, I do not know how to
install the certificate in the trusted root certification authorities store.
I can't find instructions on this.

Help is appreciated.

Macros for Excel 2007
 

Try this (I used this to install another certificate... )
1. Click on Start Run, type mmc and hit €˜Enter.
2. Select Add/Remove snap-in from File menu.
3. Click on Add, select Certificates click on Add.
4. Select Computer Accounts, click on Next and then Finish.
5. Click on Close then OK. This gives you the console to see the existing
certificates on your computers.
6. Expand the Certificate tree.
7. Right click on Certificates under Trusted Root Certificate Authorities,
and click on All Tasks import.
8. Point to the location where you copied the certificates file and come out
of the wizard by taking all default options.




"JHL" wrote:

I have a macro that works perfectly in earlier versions, but since upgrading
I can't seem to figure out the settings. When I attempt to run the macro, I
get the error
"..that macros have been disabled. To run reopen and choose enable macros."

The macros enable setting is already enabled.
The folder where the spreadsheet resides is set as a Trusted Location
I have set up my personal digital signature. However, I do not know how to
install the certificate in the trusted root certification authorities store.
I can't find instructions on this.

Help is appreciated.

Macros for Excel 2007
 

If the workbook is password protected macros are disabled by default.
Here's a solution:

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

--
Jim
"JHL" wrote in message
...
|I have a macro that works perfectly in earlier versions, but since
upgrading
| I can't seem to figure out the settings. When I attempt to run the macro,
I
| get the error
| "..that macros have been disabled. To run reopen and choose enable
macros."
|
| The macros enable setting is already enabled.
| The folder where the spreadsheet resides is set as a Trusted Location
| I have set up my personal digital signature. However, I do not know how
to
| install the certificate in the trusted root certification authorities
store.
| I can't find instructions on this.
|
| Help is appreciated.
|
|

Macros for Excel 2007
 

Thanks Jim. I just decided to remove the password and that apparently solved
it. I'll keep your instructions for when a password is needed with macros.

"Jim Rech" wrote:

If the workbook is password protected macros are disabled by default.
Here's a solution:

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

--
Jim
"JHL" wrote in message
...
|I have a macro that works perfectly in earlier versions, but since
upgrading
| I can't seem to figure out the settings. When I attempt to run the macro,
I
| get the error
| "..that macros have been disabled. To run reopen and choose enable
macros."
|
| The macros enable setting is already enabled.
| The folder where the spreadsheet resides is set as a Trusted Location
| I have set up my personal digital signature. However, I do not know how
to
| install the certificate in the trusted root certification authorities
store.
| I can't find instructions on this.
|
| Help is appreciated.
|
|