Hi, Mandy-
Would you prefer to have a button unique to the spreadsheet to launch
the macro? If you click View Toolbars Forms you should get a click
and drag menu that includes a command button (column 2, second from
the top on my version of Excel). When you use that button a wizard
pops up asking what macro to assign to the button.

Does that do it for you?

Dave O