Enable Macros

[Guest]

I have macros in a worksheet that others use. Can i have the macros enabled
without it prompting the user when they open the worksheet?
Thanks

 

[Alan]

Only if the other users set their macro security level to 'Low' which is a
potentially dangerous thing to do. Malicious code, viruses, can easily be
included in Excel macros, hence the warning on opening,. If the warning
could be disabled by the writer of the code, the virus writers would have a
field day,
Regards,
Alan.

 

[Guest]

You can use the 'selfcert.exe' program that's part of MS Office to create a
digital signature. Then you sign your macros (tools / macros / visual basic
editor, then from within the VB editor, tools / digital signature and select
your new signature).
Have your users set their security to medium (they'll have to exit and
restart Excel for the change to take effect). Then when they open your macro
file the first time, they should be prompted. Have them indicate that you
are a trusted author. Next time, the macro should be available without the
warning.