Thanks everyone for the input. It is what I figured. Was just hoping someone
knew how to tap into the macro warning message to amend it to read "by not
selecting OK" the template will not work or similar message. I was trying to
help new users to understand saying no would make the template unusable. So I
will have to display this information in the instructions (who reads them
anyway?) for the template. Thanks again all.
Jack

"Tushar Mehta" wrote:

Hi Tom,

XL2003 will not trust a self-signed certificate on a machine that lacks
the private key for that certificate -- something that should be
present only on the machine that created the certificate.

Only third party certificates (read several hundred $$ each year for
individuals) work.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
In xl2000 or later, you would need to certify your project and have the user
accept you as a trusted source.

An alternative would be to put your code in an addin and have the user load
the addin.