Markl wrote:
Excuse my ignorance but how would I do this?

Thanks

Easiest way to find your personal macro worksheet is to record a macro and
in the "Store macro in..." box select Personal Macro workbook.

Then when you go into the VBA editor, you PERSONAL.XLS in the project
explorer and you can easily add your stuff to it.

To save as an addin, just go to File-Save As... and Excel addin is the last
one in the "Save as type:" list.

HTH