How do you distribute an Excel 2003 spreadsheet application with buttons
linked to macros?

Do you actually have to relink all buttons to the macros for every new
location? I can't believe that - I must be overlooking something.

My spreadsheet has buttons which are linked to macros.

When the spreadsheet is moved to a different location (on the same computer
or a new computer), the following error occurs when a button is clicked:

"A document with the name fubar.xls is already open. You cannot open
two documents with the same name etc."

I moved all macros into the Sheet1 Excel Object. That didn't help.

I have tried using buttons from the control toolbox (which I read should
correct this but doesn't), and from the forms toolbox, and the "custom menu
item" from the macros list. Nothing works.

When I put the spreadsheet on another machine, sometimes the buttons are
there but I have to link them to the macros. Sometimes the buttons aren't
there at all.

I don't understand this and can't find anything to clarify it. Where are
the toolbars stored? Why can't the buttons just look in the current
workbook for the macros?