Best way for udf's

[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

 

[Arvi Laanemets]

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)

 

[BrianB]

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
==================================================