Hi All
I have one workbook (created in excel 2003 for Mac) with multiple sheets,
formulas & macros.
The macros are linked to buttons which have come from the form menu.

I created the macro's in the current Workbook saved in "Module 1" and all
are "General".
The macros do tasks like:

- copying the current worksheet to a new workbook & clearing out items not
required (eg. named ranges, objects, buttons, etc)
- running data updates
- formatting cells etc.
During testing - they all worked great - with and without assigning them to
buttons...

I sent the workbook to the Users who use Windows PC's - Vista - Excel 2007.
The buttons worked great on the first click... but after that the error
message "Book1 could not be found"
appeared. The buttons all re-assigned themselves to "Book1" (which doesn't
exist)?
e.g. Book1!mba

How can I make the buttons stick to the assigned macros in the current
workbook.
I can't hard code a workbook name - as the workbook will be renamed / saved
as.
Can anyone help me with a way to avoid this from happening?
--
Thank for your help
BeSmart