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)


--
(When sending e-mail, use address (E-Mail Removed))
Arvi Laanemets


"Brian Shafer" <(E-Mail Removed)> wrote in message
news3Ysb.145099$ao4.466534@attbi_s51...
> 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?

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


"Brian Shafer" <(E-Mail Removed)> wrote in message news:<o3Ysb.145099$ao4.466534@attbi_s51>...
> 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

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.

--
Regards,
Tom Ogilvy

"Brian Shafer" <(E-Mail Removed)> wrote in message
news3Ysb.145099$ao4.466534@attbi_s51...
> 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
>
>