I mail it to about 9-10 people, all listed in a Range in Excel, using your
code:
http://www.rondebruin.nl/mail/folder3/message.htm

They fill out some information on a single SS, using a few UserForms, and
mail it back to me:
http://www.rondebruin.nl/mail/folder2/mail2.htm


All the data is stored in Access. I created a work-around, using Excel,
because many people in my office do not have MS Access, or do not know how to
use Access.

I am thinking the 'Template' option may be the way to go with this. Hoever,
I think I will have to scrap the whole 'Create a workbook from every
worksheet in your workbook' idea (which, by the way, I love):
http://www.rondebruin.nl/copy6.htm

Any other ideas?


Thanks so much,
Ryan---


--
RyGuy


"Ron de Bruin" wrote:

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