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 |
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 |
All times are GMT +1. The time now is 12:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com