Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
JHL JHL is offline
external usenet poster
 
Posts: 56
Default 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.


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,805
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,718
Default 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.
|
|

  #4   Report Post  
Posted to microsoft.public.excel.misc
JHL JHL is offline
external usenet poster
 
Posts: 56
Default 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.
|
|


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 macros - how to merge 5 macros together into one Sue Excel Discussion (Misc queries) 1 April 16th 08 09:36 PM
Macros in Excel 2007 Michelle Excel Discussion (Misc queries) 3 March 7th 08 02:35 PM
Excel 2007 and macros Chimelle Excel Discussion (Misc queries) 5 September 7th 07 11:03 PM
Excel 2007 and Macros Rob[_4_] Excel Discussion (Misc queries) 4 April 19th 07 01:02 PM
Macros in Excel 2007 Graham Excel Discussion (Misc queries) 8 April 6th 07 11:59 PM


All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"