Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Buttons re-assigned themselves to the right macro name but in Book
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Buttons re-assigned themselves to the right macro name but in Book
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Macro To Change Which Macro Assigned To Command Button | Excel Discussion (Misc queries) | |||
copy macro assigned buttons in an array | Excel Worksheet Functions | |||
Macros assigned to buttons do not work when copied to CD | Excel Programming | |||
Buttons assigned to a macro | Excel Programming | |||
Problem with macros assigned to toolbar buttons | Excel Programming |