How can I add a macro that is always available?

[Rico]

Hi,

I need to make a macro, which is available at all times.
I have some macro code, which I have tried to paste into
the VB editor and then save it as a function, but this
dos'nt seem to work.

Any ideas?

Thanks
/Rico

 

[Frank Kabel]

Hi
put this macro in your personal.xls file. See the following site for
more details:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Andy Brown]

I need to make a macro, which is available at all times.

Save the workbook that contains the module as personal.xls, in your xlstart
folder. This file loads automatically (tho' hidden) whenever you run Excel.

Rgds,
Andy

 

[Rico]

Thanks guys,

I'll try it out.

Cheers
/Rico

-----Original Message-----

Save the workbook that contains the module as personal.xls, in your xlstart
folder. This file loads automatically (tho' hidden) whenever you run Excel.

Rgds,
Andy


.