NEED HELP PLEASE!! VBA code to xlSheetVeryHidden

Hi all -

I wrote code for a macro... it basically opens about 7 sheets, does it's thing, then hides the sheets again. I don't want the end user to have the ability to unhide the sheets, so I'm trying to use xlSheetVeryHidden. below is a snippet of the code, the rest doesn't really matter.... this section just hides the selected sheets.

Sheets("Sheet1").Select
Sheets("Sheet1").Visible = True
Sheets("Sheet2").Visible = True
Sheets("Sheet3").Visible = True
Sheets("Sheet4").Visible = True
Sheets("Sheet5").Visible = True
Sheets("Sheet6").Visible = True

I tried to replace the 'True' with 'xlSheetVeryHidden', but obviously got an error.

Thanks in advance!!

Originally Posted by Loganeb

Please Login or Register  to view this content.

Note: You can't make ALL sheets very hidden. You must leave one sheet visible.

Thanks so much! worked perfectly! I can't believe I didn't see that.