copy button with VBA code to another workbook

**Khalil Handal** · 11-23-2023, 04:21 AM

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

**Andy Pope** · 11-25-2023, 05:32 AM

The buttons would need to be ActiveX buttons with click event code.
You would need to Move/Copy the worksheet in order for buttons and code to be copied to a new workbook.

If you have Forms buttons then you will need to manually copy the code into the new workbook AND change the Assign Macro reference for the button.

**deadlyduck** · 11-25-2023, 12:14 PM

Has a button a parent property i.e the name of the sheet it's located on? If so, I'm reckon that it's possible to do what is required if the button code refers to the parent sheet when updating the data.

**Greg M** · 11-26-2023, 10:40 AM

Hi there,

Take a look at the attached workbook and see if it gets you moving in the right direction. It uses the following code:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.

Please note that a Reference to "Microsoft Visual Basic for Applications Extensibility 5.3" must be set in the VBA Editor.

Hope this helps - please let me know how you get on.

Regards,

Greg M