Buttons re-assigned themselves to the right macro name but in Book


B

BeSmart

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?
 
Ad

Advertisements

B

BeSmart

One more piece of information..

The buttons are named ("extractmba" = Button 6) so that specific buttons can
be nominated and deleted during one of the macros.

Thank for your help
BeSmart
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top