Hi,
I've posted a solution to this a few times, I use it for various applications and I've never had a problem.
Run the Office 2000 setup program again.
On the Select Features screen in the setup program, expand Office Tools.
Select Digital Signature for VBA projects, click the arrow next to your selection, and then select Run from My Computer.
In Windows Explorer, locate and then double-click the file SelfCert.exe in C:Program FilesMicrosoft Office\Office.
Note, Because a digital certificate that you create yourself isn’t issued by a formal certification authority, macro projects that are signed by using such a certificate are referred to as self-signed projects. Depending on how your organization uses the digital-signature features in Microsoft Office, you might be prevented from using such a certificate, and other users might not be able to run self-signed macros for security reasons. Learn about digital signatures.
Once you've digitaly signed your work, the first time you open the file on a users computer, it will ask if the digital certificate is to be trusted. You can tell XL to always trust code signed by this person.
From then on, the user's computer, regardless of security setting, files will open without disable macros prompt.
If there's any reason that this doesn't work, let me know, but from experience around the office and with applications I've sent around the state, its always worked.
HTH,
Corticus