I wanted to mail these tiny Workbooks to several people

Where can we find the mail addresses ?
Do you have the address in each worksheet ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ryguy7272" wrote in message ...
I thought I posted the code; guess not:
http://www.rondebruin.nl/copy6.htm

So, this works fine! Thanks a ton, Ron!! I know I can click/drag UF and
Modules into new books, but is there a way to identify each UF and each
Module, using code, and copy/paste those into the new Workbooks when running
the macro that I referenced above. Or, is using a template the only option?


Regards,
Ryan---

--
RyGuy


"JLGWhiz" wrote:

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