|
-
Aug 30th, 2003, 06:42 PM
#1
Thread Starter
Lively Member
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.
Last edited by Daniel McCool; Aug 30th, 2003 at 07:20 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|