Store the macro in your personal.xls file. This allows you to use the macro
whenever you have Excel open.

--
Brevity is the soul of wit.


"epicman" wrote:

I have created a macro however it will only work within that
spreadsheet. How can i write a macro so that all of my documents
(existing and new) can use this macro.

I then wish to assign a button on the toolbar that uses that macro.