Hiding Worksheets (RESOLVED)

[Daniel McCool]

I want to hide worksheets when the workbook is opened. Right now i'm using Sheets("Whatever").Visible = 2 which makes it invisible. I don't want to keep it this way, because with it being invisible, I cannot unhide it to make it show again. So what I want to do is just hide it rather than making it invisible, that way it can be unhidden if needed. I recorded a macro, then hid and unhid a sheet, all it was doing was making it invisible (the same way I am).

However, when I do this by code, it probably isn't recognizing it, so when I go to unhide it from the menu, the unhide button is inactive because it doesnt have an hidden sheets on record. I'm assuming this is the problem. Any help thanks.

[adocwra]

Sheets("Whatever").Visible = 0


this will hide and allow to unhide
2 hides it big time

[Daniel McCool]

Yeah, I wanted to hide it "big time" thinking it would be ultra protected, now I understand. THANKS!

[spicylife]

Check this link for Hiding Unhiding sheets using an easy UserForm. Explanation with screen shots
http://vbacentral.blogspot.com/2009/...sing-user.html