Try this, boo: http://vbaexpress.com/kb/getarticle.php?kb_id=448
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"becaboo77" wrote in message
...
I have a file with about 25 tabs (sheets) in it, but I want to save each
tab
as a separate file & name the file the tab name. Is there a way to do
this
automatically, or will I have to manually move each sheet into a new file
&
save it?