I don't know about Excel 2003, but Excel 2000 has a utility to create
a self-certified signature. As a true signature, its functionality is
limited, as it is not certified by any certification authority and it
can be faked. It is useful as a personal signature, or for a group of
co-workers, to keep the 'Enable Macros' dialog from popping up without
setting macro security to 'low'.
In Excel 2000, there is a file called selfcert.exe in the installation
directory. After running that utility, you will have a signature
available to sign your VBA with.
Note that you cannot export the private key with this certificate, so
it can only be used to sign code on one machine. When the file is
opened on another machine, the user will see the content dialog and
have an opportunity to disable or enable macros, or always trust
content with this signature (which enables macros automatically every
time after).
You may want to see if this utility is included in Excel 2003. Users
appreciate not having to click 'Enable Macros' every time they open a
file.
-Mike
I wrote the Macro myself, so I know it is safe, but I can't run it. I
decreased the security to low, But I don't have a DIGITAL signature of my
own to install. Can someone point me in the right direction?
Many thanks in advance.
Mike Argy
Custom Office Solutions
and Windows/UNIX applications
Please post on-topic responses to the newsgroup
To e-mail me, remove nospam from the address in the headers
