Is there a simple procedure to set my macros in Excel 2003 to be .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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 Tools>Digital Signature>Choose. 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
 
Back
Top