On Friday, April 18, 2008 5:09:19 PM UTC-4, Ron de Bruin wrote:
Hi amithere

See
http://www.rondebruin.nl/copy6.htm

If you want to mail them see this templates
http://www.rondebruin.nl/mail/templates.htm

Or a macro
http://www.rondebruin.nl/mail/folder1/mail5.htm

--

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


"amithere" wrote in message ...
My excel files usually have 50 worksheets (tabs). Each sheet needs to be
distributed to a different person as an electronic file. I keep an original
file so I can do mass updates. Right now, I'm clicking on each sheet and
saving a copy to a "new book" and then saving each new file. Is there a way
to split up all the worksheets into separate "new books" or do I have to
continue to do it one at at time?

Also, is there a way to alphabetize the worksheet tabs (sort) other than
dragging them to move them?

Thanks!

Ron

Found your macro today. Many thanks for sharing it.