Ron de Bruin has a utility to do just that

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



"Carl" wrote:

I've got a Excel workbook with over 400 worksheets in it, I need to turn each
of them into thier own work book. Are there any shortcuts?