Hi,

I recorded a macro to save a sheet and this is my code:

Sub Generate_Report_Click()


Sheets("Conversion rates").Unprotect Password:="Secret"


    With ActiveWorkbook.PublishObjects.Add(xlSourceRange, _
        "O:\Roberts Figures\Conversion Reports\" & Range("AH7").Value & ".mht", "Conversion rates", _
        "$A$1:$AC$33", xlHtmlStatic, "Coventry_15959", "")
        .Publish (True)
        .AutoRepublish = False
    End With

    Sheets("Conversion rates").Protect Password:="Secret"
   
    End Sub

Is it possible to save more than one sheet at a time but not the whole workbook?

Thanks