View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kiknadze Lado Kiknadze Lado is offline
external usenet poster
 
Posts: 12
Default how to save only one sheet as workbook

Dear All,

I have workbook with sheets: sheet1, sheet2, sheet3.
I want to save this workbook in three workbooks. First workbook should have
only one sheet (sheet1), second workbook should have only one sheet (sheet2)
and third should have also one sheet (sheet3) and workbooks names I would
like to have sheet1, sheet2, sheet3 as well.
How I can do this manually and in VBA (if I have many sheets in essential
workbook)

Best wishes,
Lado