Hi Marcster & Matt

Thanks I did that for my project and it works fine, thank you.

So say I have saved the spreadsheet with the macro in it as a template. Now I want to distribute this to lots of people on our network, and basically reduce their work load as much as possible: I really dont want to have to make them do Copy and paste of code etc. How can I distribute it (e.g. via email attachment) to their personal.xls?

Thanks...