Deploying macros

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

I've written some simple macros that I want to deploy to about 50 computers.
Rather than invest in Visual Studio Processional, I want to just copy the
Vbaprojectm.otm file to each user -- none of our users have written any
macros.

I can automate the copy easy enough, but is there a way to install the
certificate automatically? The project was signed with a certificate created
by selfcert. When I deploy the macros by copying VbaProject.otm, I get a
macro security warning. I can then manually install the certificate, but it
takes a lot of mouse clicks -- Details, View Certificate, Install
Certificate, then click through the Wizard. When the certificate is
installed I can then check the Always Trust This Publisher checkbox.

Is there a way to automate this, maybe a command line that could be added to
the bat file that copies theVbaProject.otm file?

Thanks,

--Doug
 
AFAIK you have to do it manually. It's one of the disadvantages of
distributing VBA code.
 
Back
Top