+ Reply to Thread
Results 1 to 3 of 3

Hide/Unhide rows Based on Value from Dropdown Lists

  1. #1
    Registered User
    Join Date
    12-06-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    8

    Hide/Unhide rows Based on Value from Dropdown Lists

    Hi, need help with the following

    Cell A3 has drop down list "+" & "-".
    If A3 = "+" unhide row A4:A10
    If A3 = "-" hide row A4:A10

    Attached is a Sample workbook.

    Problem 1: I have to click away from cell A3 for the code to work. How can I activate the code just by selecting the item from the list?

    Problem 2: I unlocked the cell A3 and Protected the sheet with (select unlocked cell) option. doing that rows can't be hidden or vice versa. I need this to work on a protected sheet otherwise i could have used the group/ungroup from data menu.

    Any help will be appreciated. thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Hide/Unhide rows Based on Value from Dropdown Lists

    2Deep,

    Detach/open workbook 2Deep - EF756487 - SDG10.xlsm and on worksheet TestBook cell A3 make a choice of + or -, the Plus or Minus sign.
    Attached Files Attached Files
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

  3. #3
    Registered User
    Join Date
    12-06-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Hide/Unhide rows Based on Value from Dropdown Lists

    Stan your code works buddy on the unprotected sheet,

    but how to make it work on the protected sheet.

    thanks again for the quick reply.
    Deep

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1