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