Macro's assigned to a custom toolbar button don't run after renaming the worksheet

I have to simple macros assigned to two different buttons on a custom toolbar. It works fine until the location of the worksheet (or the worksheet name) is changed to another directory. When opening the worksheet and using the toolbar, an error message is shown that the macro couldnīt be found on the original file location.

Of course, the macros are in the workbook and can be reassigned to the toolbar again....

Anyone knows how to make these macro mappings independent of the worksheet's file location (or worksheetīs name)?

Marcel

Do you assign the macros in code or via the user interface? If the former, can you post the code?

I have a similar problem .. but for me the macro still runs but if I use the toobar icon it refers back to the old worksheet

Sorry for the delay in responding, and please do edit your post to add code tags as mudraker requests.

I reckon you create hard-coded links to the workbook path when you assign a macro to a toolbar button via the UI (I know this is true for macros in add-ins). Try assigning the button in the workbook open event.

Is that to assign the macro to a toolbar custom button ... I cant work out how to do ?