Macros for Excel 2007


J

JHL

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

Advertisements

S

Sheeloo

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

Jim Rech

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

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

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

Advertisements

J

JHL

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top