Encrypt Or Hide Macro

  • Thread starter Thread starter Ant Nutting
  • Start date Start date
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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Encrypt or Hide Macro 2
Macro to hide cols 2
All macro are disabled due to encryption? 4
2007 cannot enable macros? 4
Hide column if it contains text 7
vba code to enable macros 3
Macro for hiding/unhiding a set of rows 3
HIDE-UNHIDE VBA MACRO 1

Back
Top