Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros disabled
I have a workbook with six worksheets, divided by work function. At a
weekly meeting we need to print the report. I recorded a simple macro to print selected worksheets. Today when I tried to run it, I received the following message: "Macros in this workbook are disabled because the security level is high, and the macros have not been digitally signed or verified as safe. To run the macros, you can either have them signed or change your security level.." 1) How do you digitally sign a macro? 2) The security level on my machine is medium, should be it be raised or lowered? Thanks for your help Frank |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros disabled
You'll need to lower it in order to make the macros run, but it's something
that you're gonna want to be sure you understand the repercussions. Your system administrator set it to medium most likely because it's their default setting. Lowering it will open you up to certain risks. My humble opinion is to make sure with your SA it's allright first. "FJB" wrote: I have a workbook with six worksheets, divided by work function. At a weekly meeting we need to print the report. I recorded a simple macro to print selected worksheets. Today when I tried to run it, I received the following message: "Macros in this workbook are disabled because the security level is high, and the macros have not been digitally signed or verified as safe. To run the macros, you can either have them signed or change your security level.." 1) How do you digitally sign a macro? 2) The security level on my machine is medium, should be it be raised or lowered? Thanks for your help Frank |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros disabled
It seems a bit strange to me. Normally, if you set security at Medium,
you should be prompted to enable macros. (Excel 2000 has Low, Medium, High; 2003 has Very High). However, you can easily run macros even with security set at high. You have a few options rather than changing your security level: (1) Store the macros somewhere automatically trusted e.g. (a) Store the macros in your personal.xls. (b) Store your macros in a separate AddIn and install the AddIn. Both of these options should allow the macros to be run, even with securiry set to high. (2) Alternatively (and to answer your first question) you can sign the project. This in general works very well. You have two options (I hope I have them the right way round). (a) selfcert.exe - lets you create a unique signature key for your machine. This is the simpler method but you can't easily export the key so you must resign if you or someone else makes changes from a different machine or login--shouldn't be a problem if it's just you using it. Likewise, if you get a new PC, you will need to create a new one. (b) makecert.exe - lets you create an exportable signature key. This way, a bunch of you can share it (if multiple users need to edit the VBA code) and you can easily export it to a new machine. [I've experienced problems with this key just giving up the ghost and refusing to work at times though. I'm not even mentioning the idea of buying a signature here. Far too pricey if you ask me. HTH, Gareth FJB wrote: I have a workbook with six worksheets, divided by work function. At a weekly meeting we need to print the report. I recorded a simple macro to print selected worksheets. Today when I tried to run it, I received the following message: "Macros in this workbook are disabled because the security level is high, and the macros have not been digitally signed or verified as safe. To run the macros, you can either have them signed or change your security level.." 1) How do you digitally sign a macro? 2) The security level on my machine is medium, should be it be raised or lowered? Thanks for your help Frank |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros disabled
It's not a problem of the security on your entire machine.. It's matter of excel's security feature. Tools - Macro - Security... [Select Medium] This will prompt you on if you want to 'enable macros' each time yo open a worksheet that contains macros. If you trust the source, the you can enable it; perfectly safe if you trust the source of th spreadsheet. Garret -- prepotenc ----------------------------------------------------------------------- prepotency's Profile: http://www.excelforum.com/member.php...fo&userid=2415 View this thread: http://www.excelforum.com/showthread.php?threadid=38659 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros disabled
This workbook is accessed by five other people. What is the effect of
saving the macro in my personal.xls? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros disabled
The macros will only be accessable to you...
-- steveB Remove "AYN" from email to respond "FJB" wrote in message ups.com... This workbook is accessed by five other people. What is the effect of saving the macro in my personal.xls? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros are disabled . . . and they shouldn't be | Excel Discussion (Misc queries) | |||
Macros are disabled | Excel Discussion (Misc queries) | |||
macros disabled | Excel Programming | |||
macros disabled | Excel Programming | |||
disabled macros | Excel Programming |