Question About customized menu bar

[filo666]

Hi, I made a customized menu bar and I have the problem that when I copy my
Excel file to another computer and I press a button of my menu bar, The
button doesn’t find the macro, so I need to define again which macro
correspond to which button, ¿how to save the root directory with the macro so
whatever computer is my Excel worksheet run, the macro is assigned to the
customized button on the menu bar.

TIA

 

[Bob Phillips]

Build the menu in workbook open. See http://tinyurl.com/9f5vw for an example

 

[STEVE BELL]

If the workbook creates it's own menu bar it should work OK.

Share your code...