+ Reply to Thread
Results 1 to 3 of 3

Making sheets visible or hidden based on value of a range of cells.

  1. 10-10-2012, 08:57 AM #1
    alzhander
    alzhander is offline
    Registered User
    Join Date
    10-10-2012
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Making sheets visible or hidden based on value of a range of cells.

    My apologies if this is already answered elsewhere, I have searched and searched and was not able to find a working solution. Here is my problem:

    I am making a sheet for 3.5e D&D that does most of the math for the player, and I have a sheet for each of the basic classes. The first sheet in the workbook is Sheet12 named "Beginning & Level ups" and each class sheet is named for the class (barbarian, bard, cleric, etc.). I have cells on 'Beginning & Level Ups' for choosing which class you want to take at what levels, and I want each class sheet to be hidden until the name of the class is present in a cell in 'Beginning & Level Ups'. The range for the cells is G29:G185. For instance, if I enter into cell G29 on Sheet12 the word "cleric" I want the Cleric sheet to be visible to the user, but hidden if "cleric" is not present in any cells within the range of 'Beginning & Level Ups'!G29:G185, visible if "cleric" is in any cell of the same range.

    Any help would be greatly appreciated, or a link to an answer that was already provided that I somehow missed.
    Thanks in advance!
    Reply With QuoteRegister To Reply
  2. 10-10-2012, 09:11 AM #2
    Bishonen
    Bishonen is offline
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Re: Making sheets visible or hidden based on value of a range of cells.

    please attach an example worbook
    If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.
    Reply With QuoteRegister To Reply
  3. 10-10-2012, 09:12 AM #3
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Making sheets visible or hidden based on value of a range of cells.

    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1