Protecting Functions (VBA)

[Rutgers_Excels]

Frank,

Thanks for the reply.

However, when I save the user defined functions as an add-in t
someone's computer, you are still able to see the code if you go to th
VBA editor. Am I doing this incorrectly?

Also, do you know if it is possible to do the second part of m
question, which is load a macro that can be used in any spreadsheet

 

[Frank Kabel]

Hi
if you assign a password to the VBA project (your add-in9
and lock this project you can't see the code

 

[icestationzbra]

the answer to the second part of your question is:

you could put this particular file in the XLStart folder in you
machine. it usually resides in "Program Files\Microsoft Office\Office
folder. when excel files are kept in this folder, they are loaded ever
time excel is opened. hence, any functions, macros, toolbars et a
reside in that file, also get loaded. you could record a macro t
create a toolbar, or add an icon to a toolbar and put it in this file
when this file opens by virtue of being in the XLStart folder, the men
item and/or toolbar will be created and will be accessible to any exce
file currently open