Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there a simple procedure to set my macros in Excel 2003 to be .
I have tried to create a digital signature as instructed in Help. I created
it, but it is not in a trusted zone or something like that. How can I set Excel 2003 so that I am free to create and use macros? |
#2
|
|||
|
|||
Shelley
I assume you created the certificate/signature using the SelfCert tool in Office. Also, your Macro Security is set to "medium". With your workbook containing macros open, hit ALT + F11 to get to Visual Basic Editor. Select your workbook/project and ToolsDigital SignatureChoose. Pick the certificate you created and OK your way out. Save the workbook and close it. Re-open and when the alert comes up, checkmark the option at "always trust etc." This message will not come up again if your Macro Security is set to "medium". Your workbook will not display the macro warning when opened. If you really want the certificate in your Trusted Certificates folder, post back and I can explain how to do that. Should not be necessary if above steps are followed. As an aside..........you can still create and run macros without a Signature, you will just have to acknowledege the macro warning every time. Gord Dibben Excel MVP On Thu, 21 Apr 2005 20:54:02 -0700, "shelley" wrote: I have tried to create a digital signature as instructed in Help. I created it, but it is not in a trusted zone or something like that. How can I set Excel 2003 so that I am free to create and use macros? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enabling macros | Excel Discussion (Misc queries) | |||
sorting with macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) | |||
Macros disappear after a file is imported | Excel Discussion (Misc queries) |