Hello all,
I am using a spreadsheet that has macros. I have created custom tool bar
buttons to launch the macros.

When I assign the macro to the button, it specifically assigns the macro by
spreadsheet path and name!macro name

This is causing problems when I share this document with others, for
example, the button is clicked and it tries to open the macro c:\documents
and settings\David\macro1
No one else has that path and file except me.
is it possible to just use the macro1 within the document and not have the
full file name and macro assigned to a button?