Protecting Functions (VBA)

R

Rutgers_Excels

Is there anyway I can add protection to user defined functions which
have written? I loaded the functions on to several of my co-workers
computers and I don't want them to be able to access (mess up) th
code.

Also, is there anyway to use the add-in feature or some other featur
to link a macro to the menu bar so that it could be used on an
spreadsheet that I open on my computer
 
F

Frank Kabel

Hi
in the VBA editor open the vBA properties of your projct
and on the 'protection' tab choose a password.
Note: This protection is quite weak
 
Top