In your macro, use references/qualifiers like
ActiveSheet
ActiveWorkbook
ActiveCell

Then the macro will work on the sheet that has the focus. It doesn't matter
that the code is located in a different workbook (as long as the workbook
with the code is also open).

--
Regards,
Tom Ogilvy


"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