I am looking to write a macro that takes worksheets from a workbook, protect them, save them to idividual workbooks and then email each individual workbooks to nn addresses. All of this off of minimum key strokes.

The macro to protect, copy, and resave worksheets as a new workbook is fine, but I am struggling to email the individual worksheets off of the same macro function. Any ideas would be welcomed.

With grateful thanks

TC

Tomcat57 explained on 7/3/2012 :
I am looking to write a macro that takes worksheets from a workbook,
protect them, save them to idividual workbooks and then email each
individual workbooks to nn addresses. All of this off of minimum key
strokes.

The macro to protect, copy, and resave worksheets as a new workbook is
fine, but I am struggling to email the individual worksheets off of the
same macro function. Any ideas would be welcomed.

With grateful thanks

TC

You'll find very helpful examples listed here...

http://www.rondebruin.nl/tips.htm

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion