Sorry, I worked that out just after I posted my reply. So:

I have a macro/sub called OpenST that everyone has saved in their Personal.xls;

I export that to a module saved as OpenST.bas say;

Create a workbook and embed the code you suggested, send this around and users run it;

What happens then? Ideally I would need it to go into personal.xls and overwrite the code in the OpenST sub with the new stuff.

Thanks for your assistance