Thu, 31 Jan 2008 01:22:00 -0800 from NSNR :
I have created a macro ...

Now I want to use this macro to be used while working for projects in
different worksheets,

http://www.rondebruin.nl/personal.htm says "If you want that certain
code is available in all your workbooks, then use your
PERSONAL.XLS or in Excel 2007 your PERSONAL.XLSB file." and explains
how to do it.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/