Paresh,

Personal.xls is a macro library. To create one, turn on the macro recorder,
and when prompted as to where to save the macro, choose "Personal Macro
Workbook" Then click Ok, click the stop button, then go into the VBE using
Alt-F11, and your personal.xls will be available there for you to store
macros in and have them available every time you open Excel.

HTH,
Bernie
MS Excel MVP

"Paresh" wrote in message
...
Bernie,

Thank you for your suggestion. It seems to do the trick. My question
though is what is 'personal.xls'? How do I write this code such that the
function is available at all times for any spreadsheet I load?

Paresh