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

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

Thx for the help guys

You can protect the project where your macro is located.
In project window, right click the project Project properties Protection Ta

----- Ant Nutting wrote: ----

Hi Al

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

Th