Macro

  • Thread starter Thread starter marc747
  • Start date Start date
M

marc747

I have a excel file that has some Macros in it, some times when others
try to use it the macro does not work either because the macro
security setting or other reasons. so my question is, is there a way
to place another Macro in the file so that when a person opens the
file the Macro is automatically enabled regardless of there settings.
Thanks.
 
Bob is right. However, you can add a digital signature to the project. With
the modulue open choose Tools, Digital Signature. You can then create a your
own digital signature.

Each user can then agree to accept files using your signature Tools, Macros,
Security On the Trusted Publishers tab they can choose to accept your files
with your signature. After that they will not be prompted when the file is
opened and the maro will not be disabled.

Regards
Peter Atherton
 
Back
Top