Results 1 to 4 of 4

Thread: Hiding Worksheets (RESOLVED)

Threaded View

  1. #1

    Thread Starter
    Lively Member Daniel McCool's Avatar
    Join Date
    Oct 2002
    Posts
    127

    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
  •  



Click Here to Expand Forum to Full Width