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 doesnt 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

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

--
HTH

Bob Phillips

"filo666" wrote in message
...
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

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

Share your code...

--
steveB

Remove "AYN" from email to respond
"filo666" wrote in message
...
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