Functions

J

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
 
J

Jack

Hi There;

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

Please help.

Thank you,
Jack
 
J

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.
 
J

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
 
Top