Protecting Functions (VBA)

  • Thread starter Thread starter Rutgers_Excels
  • Start date Start date
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
 
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
 
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

how to protect cells? 4
problem with macros and protections 5
Protecting Functions (VBA) 2
Macro Compatability 1
Protecting a single column 4
Making macros unvisible 5
Having a macro/function available in new spreadsheets 1
lock only formulas, not worksheet 2

Back
Top