Hi all
I have a custom toolbar in an Excel spreadsheet with 4 menu items. I have tried to assign a macro to each, but these then only work for one time.
I have used:
Tools / customise
Then right click on the menu item
Then assign macro
Basically, I have tried all 3 options in the Assign Macro box ( All open workbooks, This workbook and the specific workbook name). Whichever one I try and then chooose the macro to assign, it works the first time and then on later attempts comes up with various errors. One seems to be trying to re-open the workbook.
Has anyone any advice?
Thanks
Bookmarks