Hiding Worksheets (RESOLVED)
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.
Re: Hiding Worksheets (RESOLVED)
Check this link for Hiding Unhiding sheets using an easy UserForm. Explanation with screen shots
http://vbacentral.blogspot.com/2009/...sing-user.html