How to save only one Worksheet not entirely Workbook

[amecari]

I have a workbook with 05 worksheets, but I want to salve only 03 (three) .It`s possible ? How could I write this ?
Is possible too to save a workbook that have macros without save this ???
Thanks .

 

[xlbo]

Hmmm - to save one sheet only, you could save as .csv (comma seperated values) - this will only allow you to save one sheet. To save 3 out of 5 you're gonna need some code to copy the 3 sheets you want to a new wb and then save that. OR, you could use some code to make the 2 ws you don't want "veryhidden" - so you can't just go to sheets > unhide.

ps .csv file will not save macros either.

HTH
Geoff