Best way for udf's

  • Thread starter Thread starter Brian Shafer
  • Start date Start date
B

Brian Shafer

Hello,
I am not sure how to do this. But I have some user defined functions that I
would like availible in all my excel files. I do I make this perminant?
I'd also like to password protect this, so it would not be real easy to view
the code for the functions.
Any help or ideas?
thanks,
Brian Shafer
 
Hi

You have to save them in your Personal Macro Workbook (Personal.xls), placed
in Office's XLSTART folder.

To protect the code from users, you have to protect the VBA-Project (In VBA
Project Window, right-click on project and select
VBA-ProjaetProperties.Protection)
 
1. Keep your udfs in a workbook (usually, but not necessarily, called
personal.xls) and put it into your XLSTART folder so it will open when
Excel opens. The workbook is usually kept hidden.

Password protect code via VB Editor Tools/VBS Project Details.

Regards
BrianB
==================================================
 
If you want to be able to do

=Myfunc(A1)

then make your workbook and Addin.
The select it in Tools=>Addins.

You already received advice on protecting he project. You should give your
project a unique name first, rather than the default VBAProject.
 
Back
Top