View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Macro Start Autorun without Enable security

Paul Hi

Thanks for the comeback. I found the file and self
certified. But how do you install the certificate when you
autorun the macro?


Jack

-----Original Message-----
"Nick Hodge"

wrote in message
...
Jack

<snip
sign the code project with a paid
for security certificate

<snip

you don't have to pay for a security certificate. Do a

search for
selfcert.exe (comes with office) and run it. You can

create your own
certificate that is then used to sign the vba. When you

run the macro,
install the certificate and from then on, everything you

sign will always
run, even if security is high. Once everyone installed my

certificate, all
macros run. We have used this at our office with much

success.

Paul D


.