save each worksheet as seperate workbook

Hi,

I have a workbook containing many sheets and each sheet i manually save in a folder as a seperate workbook. Is it possible to have a macro execute this task? A macro that saves each worksheet in a workbook as individual workbooks? I searched online but none works in my workbook.

Any input is much appreciated!

Hi
Try

Please Login or Register  to view this content.