Functions

[Jack]

Hi All;

I have some standard funcations written to one worksheet in module.

I want that function to be used in any worksheet I open with excell.

Can I add them as dll or module to standard.

IF yes then how? -

Thank you in advance.

Jack

 

[JLGWhiz]

Check out this site:

http://www.rondebruin.nl/personal.htm

 

[Jack]

Awsome

Thank's JLGWhiz - I will try this out and update.

 

[Jack]

Awsome

Thank you JLGWhiz - I will try and update

 

[Jack]

Hi There;

I tried but I am not able to add the file into references.

Please help.

Thank you,
Jack

 

[JLGWhiz]

What do you mean by add the file into references? As I understand the use of
the Personal.xls, it goes into the ExcelStart folder so that it is opened
automatically when Excel starts up. I don't know about adding anything into
references. If you are referring to Add-Ins, then that is a totally
different ballgame.

 

[Jack]

Hi

My expection was creating a class or class module with standard procedure
and
addthem to tools - references and refere them when ever req. in any excel
files.

I might need to create dll or what.

and How I can refer this files in excel as library.

Thank you very for your help, apriciated.

Jack

 

[JLGWhiz]

maybe this site will help.

http://www.ozgrid.com/VBA/excel-add-in-create.htm