Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. | | |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Macros in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 and macros | Excel Discussion (Misc queries) | |||
Excel 2007 and Macros | Excel Discussion (Misc queries) | |||
Macros in Excel 2007 | Excel Discussion (Misc queries) |