Hi Keerthy,

Open a new workbook and paste the code into the ThisWorkbook module. Then,
save the workbook, with a suitable name, selecting 'Template' in 'Save as
Type' dropdown.

Thereafter, any workbook opened from the template, will have the same
functionality.

If you truly want this code in *all* new workbooks, then open the default
workbook template (Book.xlt) in the XLSTART folder, paste the code and save.

---
Regards,
Norman



"S K" wrote in message
...
Hello Norman Jones,

Thanks! that helps. I was wondering if I have to cut and paste this in
every workbook!? Can't this be available on the excel immeterial of
which work book (file) I'm working on?

-Keerthy


*** Sent via Developersdex http://www.developersdex.com ***