+ Reply to Thread
Results 1 to 2 of 2

Hide Rows/Show Rows - Check box

  1. #1
    Registered User
    Join Date
    02-04-2011
    Location
    Visalia, CA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Hide Rows/Show Rows - Check box

    Situation is:

    Overall rows 7 - 42 will be hidden, when I click on check box 1, I want it to unhide rows 7, 13, 19, 24, 30, 36, and 41 - with the remaining rows within the entire (7-42) range still hidden (unless they were previously unhidden with the check box click). Then when I click on check box 2, it will unhide rows 8-10 - leaving the remaining rows hidden (unless they were previously unhidden with the check box click). Then when I click on check box 3 it will unhide rows 11-12 - leaving the remaining rows hidden (unless they were previously unhidden with the check box click).

    Originally the subsequent check boxes weren't working because the 1st check box was overriding. I started to do a 'nesting' effect, but the check boxes wouldn't stay locked in their original spots, it would hide / show the rows for the most part but toward the end it was moving check boxes all over the spreadsheet. I tried using format control to lock but it was unsuccessful.

    Any thoughts?

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: Hide Rows/Show Rows - Check box


    It sounds like you are trying to filter data, maybe supply a simple sample of what you want accomplished in an attached workbook.
    Check the forum rules on how to attach a workbook.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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