Put the macro in the Personal.xls file, and it will be generally available.

--
HTH

Bob Phillips

"David Goodall" wrote in message
...
Hello All,
I'm trying to put together a macro that will clean a spreadsheets prior to
it being saved in a CSV file format. I need to remove the £ % , from the
spreadsheet.

My problem is that I want to access the spreadsheet from my spreadsheet
rather than adding the macro to each of the spreadsheets I'm dealing with.

Hope this makes sense.

Thanks
David