View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Peter Huang [MSFT] Peter Huang [MSFT] is offline
external usenet poster
 
Posts: 225
Default Code signing a VBA macro in 2002 and 2003

Hi

Do you mean after sign the code, you still can not run the macro?
Have you tried to add the CA publisher in the trusted publisher list.

Add a macro developer to the list of trusted publishers

If you haven't already done so, set the macro (macro: An action or a set of
actions you can use to automate tasks. Macros are recorded in the Visual
Basic for Applications programming language.) security level to Medium or
High.

How?

On the Tools menu, click Options.
Click the Security tab.
Under Macro Security, click Macro Security.
Click the Security Level tab, and then select the security level you want
to use.
Open the file or load the add-in (add-in: A supplemental program that adds
custom commands or custom features to Microsoft Office.) that contains
macros certified by the macro developer that you want to add to the list.
In the Security Warning box, select the Always trust macros from this
publisher check box.


Modify the list of trusted publishers for macros
http://office.microsoft.com/en-us/as...356731033.aspx

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.