Hi Ryan, The easy way to do it is to open your master workbook and a tear
off workbook at the same time. Then open the VB editor. Find the UserForm
in the master workbook project listing that you want to copy to the tear off,
left click and hold then drag and drop to the tear off workbook project
listing. It takes the code
right along with it.


"ryguy7272" wrote:

I am using Ron DeBruin's code to tear off sheets and append a specific sheet
to each sheet that is torn off. I wanted to mail these tiny Workbooks to
several people, but they need a certain macro in the original workbook to
fill out some UserForms and email the sheets back to me. When I create the
tear off sheets, the none of the macros follow the copied/saved sheets and
none of the UserForms follow the tear off sheets either. I guess I can use
Private Subs and those will be copied several times to the new Workbooks,
right. There are six UserForms, all named UserForm1-UserForm6. Is there a
way to force those UserForms to be copied to each new Workbook that is
created?

Regards,
Ryan--

--
RyGuy