Encrypt Or Hide Macro

A

Ant Nutting

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
 
C

Chip Pearson

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
 
C

chris

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
 
Top