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