merge two workbooks

L

Legacy 287389

Guest
Hi good people,

I have two workbooks which both contain at least 10 sheets each, and all sheets contain vba. Both books contain buttons, and userforms, etc. I have manually copied all sheets of the one book into the other, only to find that all buttons, userforms, etc, renames. so, when I press a button to run some code, the object is not found..I am wondering if there is a way to merge these workbooks EXACTLY as they are. I have renamed sheets in one book,as there were duplicate named sheets, so that has been taken care of...

all and any help will be greatly appreciated!
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
You must log in or register to reply here.

Similar threads

M
  • Question
VBA help required in creating multiple workbooks from one workbook.
Replies
5
Views
284
jolivanes
jolivanes
D
  • Solved
Save multiple sheets in a new workbook
Replies
4
Views
283
Dave_george
D
M
  • Question
Insert merged row into Excel, with duplication of the row(s) formatting above, using Command Button
Replies
1
Views
390
sxhall
S
AndyTampa
  • Solved
Limit Quick Tasks macro to a specific worksheet
Replies
4
Views
52
mumps
mumps
Smerdis13
  • Solved
VBA to Merge Multiple sheets in Workbook by cheking sheet name
2
Replies
14
Views
461
Trebor76
T

Forum statistics

Threads
1,214,978
Messages
6,122,549
Members
449,089
Latest member
davidcom

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top