I have a template wb that starts with two tabs, a instructions and variables. My macro exports reports from SAP, reformats them, and moves them to the template wb. After that function is done, I'm trying to hide the beginning two tabs, then copy and save the Wb with the code below. After the macro makes a copy, saves, and closes that wb, the template file shows both beginning tabs hidden. However, when I look at the copied and saved file, only one of the beginning tabs is hidden. I'm not sure if it's a problem with the code, or if excel just still thinks that I only have two tabs total and doesn't want to hide the last one. Any help is appreciated.

Sub Save()
Dim SaveMonth As String
Dim Year As Integer
Dim Filename As String
Dim Path As String

Sheets("Variables").Select
SaveMonth = Range("G2")
Year = Range("C2")
Filename = Year & "." & SaveMonth & " " & "Stock" & " " & "Variance.xlsx"
Path = "\\pusehf0q\SEV_Public\Calabrese\Budgets\2017\Gulley\FT4000\Stock Variance\"
'Hide sheets
Sheets(Array("Variables", "Instructions")).Visible = xlSheetHidden
'Save function
ActiveWorkbook.Sheets.Copy  'copy all sheets to a new workbook
ActiveWorkbook.SaveAs Filename:=Path & Filename, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False 'Save copied workbook
ActiveWorkbook.Close False 'close the saved copy
End Sub