VBA to hide sheets when save button is pressed

[kylehawkins79]

Is there a VBA or macro that can hide certain sheets when the save button is pressed? Thank you

 

[Fluff]

How about

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
   Dim Ws As Worksheet
   
   For Each Ws In Sheets(Array("[COLOR=#ff0000]Sheet1[/COLOR]", "[COLOR=#ff0000]Sheet2[/COLOR]", "[COLOR=#ff0000]Sheet3[/COLOR]"))
      Ws.Visible = xlSheetHidden
   Next Ws
End Sub

Change the names in red to match your sheet names

 

[kylehawkins79]

like a charm, thank you!

 

[Fluff]

You're welcome & thanks for the feedback