You can password protect the VBProject. In VBA, go to the Tools
menu, choose VBA Project Properties, then the Protection tab.
There, check the "Lock Project For Viewing" tab, and assign a
password. Note, however, that there are products available that
can defeat the password protection. There is no foolproof way to
protect your VBA code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Ant Nutting" wrote in message
...
Hi All

Hopefully someone out there can help me!
I have written a macro that will auotomatically retreive fields
from a
database. How can i encrypt or totally hide the macro, so that
users will
not be able to see what is contained within the macro?

Thx