Hi to all,
I have five buttons with VBA code in an Excel sheet. I want to copy these buttons with their code to another workbook.
The code has name range for each button.

When I use copy and paste to the new sheet in a different workbook, the macro refers to the original sheet and not the current sheet. Is ther a way to copy the code for each button?

In other words:
How to copy " command button" from one sheet to another sheet - including the code?

Khalil