I have a Workbook with about a dozen different sheets. I need to make a copy of just One of those sheets into a new Workbook and attach it to an email for distribution. >> No problem there.
My problem is, on this sheet, (while still in the original WB), I have a UserForm which is activated by buttons. When I copy this Sheet to the New Book the associated Codes and UserForm doesn't copy over.
Currently my Buttons are from the Forms toolbox. I know that I can change it to an ActiveX button and the code will follow.
Is there a way to import the UserForm from the original Book to the newly created Workbook that only has this sheet?
What I was hoping to do is have another Sub that would do this task automatically instead of, once the new book is created, copy over the UserForm manually.
I'm thinking that this Question has been asked in the past, but I can't find a solution with Search(s).
My problem is, on this sheet, (while still in the original WB), I have a UserForm which is activated by buttons. When I copy this Sheet to the New Book the associated Codes and UserForm doesn't copy over.
Currently my Buttons are from the Forms toolbox. I know that I can change it to an ActiveX button and the code will follow.
Is there a way to import the UserForm from the original Book to the newly created Workbook that only has this sheet?
What I was hoping to do is have another Sub that would do this task automatically instead of, once the new book is created, copy over the UserForm manually.
I'm thinking that this Question has been asked in the past, but I can't find a solution with Search(s).
