Authoring Excel Macros

[Guest]

I would like to "author" a macro so that when someone opens
the file which has the macro they know it's me who wrote it and
not some anonymous malicious "virus-spreader".
Typically, if a workbook that has macros is opened, the message
"enable / disable / etc" appears. First reaction: disable them.
However, if a trusted name appears, it would provide more confidence
that it's safe to enable the macros.
Thanks for your comments.

 

[Stephen Bullen]

Hi Jvillagra,

I would like to "author" a macro so that when someone opens
the file which has the macro they know it's me who wrote it and
not some anonymous malicious "virus-spreader".
Typically, if a workbook that has macros is opened, the message
"enable / disable / etc" appears. First reaction: disable them.
However, if a trusted name appears, it would provide more confidence
that it's safe to enable the macros.
Thanks for your comments.

To do that, you'll need to buy a digital signature (e.g. from Thawte -
www.thawte.com) and use it to sign your code. The users will then see
that you've signed it and can trust it.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk

 

[Ed]

Please excuse me for jumping in - but isn't there a way you can create your
own signature file and assign it to your macros? I did something of the
sort for a Word macro once (although I promptly forgot the instructions
after finishing!).

Ed

 

[Stephen Bullen]

Hi Ed,

Please excuse me for jumping in - but isn't there a way you can create your
own signature file and assign it to your macros? I did something of the
sort for a Word macro once (although I promptly forgot the instructions
after finishing!).

Yes, you can use selfcert to create a digital signature for use on your own
machine (which can then be transfered to other machines if you want), but
sending that file to someone that doesn't have that signature installed will
give (different) macro warning message.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk

 

[Guest]

Thank you Stephen / Ed, you've been most helpful.