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
 
Go to the VBE, right click the project from the browser on the left an
select "VBA Project Properties"

On the second tab you should be able to set a password and lock it.

Dunca
 
You can also hide by putting this as the first line on the module

Option Private Module
 
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 3
How do I enable macros in an encrypted document? 1
Hide and lock cell formulas without affecting Macro? 4
diable macro if a certain sheet is active 3
After Macro runs, no cell activated - what am I missing? 2
Macros - variable columns 1
Excel 2007 .xlsm file. Macro Security options not available. 1
macro showing and hiding detail 1

Back
Top