Results 1 to 3 of 3

Unhiding and Hiding Worksheets based on a range of values

Threaded View

  1. #1
    Registered User
    Join Date
    09-30-2008
    Location
    Fremont
    Posts
    21

    Unhiding and Hiding Worksheets based on a range of values

    Hello Folks.

    ive got a workbook, that has a worksheet called Query that If you type a number in a Given cell in this case H2. It returns the Sheet names (that are hidden ATM) on the same sheet in cells E15-E51. Sheet names are in mmm dd,yyyy format. What i would like to see happen is that if any of sheet names appears anywhere in E15-E51, I want the workbook to show those sheets and those sheets. If E15-E51 dosent have anything dont show sheets. FYI 2 Sheets Must be Exempt from the Rule. Sheets named BLANK, Query. make sence?? Please see my attachments below. Thank you so much.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Button For Hiding & Unhiding Rows
    By LAWDAWG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2008, 04:37 PM
  2. Hiding and unhiding rows - two scenarios
    By EdMac in forum Excel General
    Replies: 6
    Last Post: 02-08-2007, 02:16 PM
  3. Hiding / Unhiding rows when multiple cell values change
    By waverider in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2006, 08:35 AM
  4. Hiding and unhiding column automaticaly when a cell value changes
    By titovalle in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-20-2006, 09:08 PM
  5. Hiding or unhiding a picture
    By krabople in forum Excel General
    Replies: 3
    Last Post: 11-08-2006, 01:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1