Distribute Excel Macro

[JP SIngh]

Hi All

We regularly write Excel VBA macros for our internal users.

The problem is by default on all user machines the macro security is set to
high and in most cases users are not able to run the macros we send them.

Can someone give us an idea how to implement the macros we create without
having to change the security on every single machine?

Many thanks

 

[Bob Phillips]

Create an add-in and distribute that.

 

[Tom Ogilvy]

Anything in these to help?



http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/odc_dsvba.asp
Code Signing Office XP Visual Basic for Applications Macro Projects

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q288985
XL2002: About Digital Signatures in Excel Workbooks

http://support.microsoft.com/default.aspx?scid=kb;en-us;820738&Product=ofw
About Digital Signatures and Code Signing in Workbooks in Excel 2003

http://support.microsoft.com/?KBID=206637
OFF2000: Overview of Digital Certificates (Q206637)

http://support.microsoft.com/?KBID=217221
OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects
(Q217221)

Regards,
Tom Ogilvy