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
 
D

DNF Karran

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
 
D

Don Guillett

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

Option Private Module
 
Top