How do I run macro before saving a file

[Alpacino]

I like to make sure a macro "Hidesheets" runs before users save the file what will the vba code be and where would it put??
Regards
Alan

 

[wigi]

In the "ThisWorkbook" section, add:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
   Hidesheets
End Sub

Please use the Search button next time, these kind of questions were asked so many times before you.

Wigi

 

[Alpacino]

I will do thanks