Show the Sheet = Sheets("Sheet1").Visible = xlSheetVisble = -1

Hide the sheet = xlSheetHidden = 0

Really hide the sheet do the User cant use the Excel Menu to show it = xlSheetVeryHidden = 1



The error accord after a user saves and try to close the sheet.
That's because that is the first time that code is ran.

After any bit of coding, use the VBA Menu Item "Debug" >> Compile to find most of those errors without running the code.

Also, putting Option Explicit at the top of all your code pages will show a lot of errors before you even compile.