Macro Security Warnings

[Quin]

I would like to include macros in spreadsheets I create to share them with
novice users in my office. I want to find the best way to deal with the
Macro Security warnings for the novice users. I have never tried using a
“digital Signature†but that route is probably not what I want because it
probably costs money and it is just as bad to get a novice user to accept a
digital signature. Also I do not want to have to go through the formality of
working with my companies IT department every time I make a macro for
co-workers.

Is there any other options to consider? This issue has stopped me from
doing many little projects that would help others and help me learn more
about VBA and macros in Excel.

Quin

 

[JP]

Consider creating an add-in. There's no security prompt because by
their nature, add-ins have to be manually installed by the end user.
Do a search for "how to create excel add-in" and you should get many
hits.

You could also self-sign your projects. This would be useful in a
"trusted" environment like you describe. See http://www.howto-outlook.com/howto/selfcert.htm

--JP