Results 1 to 8 of 8

Hide and Unhide sheet based on Checkbox status

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-08-2011
    Location
    London
    MS-Off Ver
    Work Office 365 Home 2019
    Posts
    428

    Hide and Unhide sheet based on Checkbox status

    Hi Guys,

    There's a part of me that thinks this should be straightforward.

    What I'm looking to achieve is that when the Checkbox on the DSR sheet is checked, the sheet called "MOTP is unhidden (and cell b2 of MOTP is selected)

    If the Checkbox on the DSR sheet is unchecked, the sheet MOTP is cleared of any date entered and hidden (for the purposes of this exercise, let's assume data has been input in to cells B4, B6 and B9 of the MOTP sheet).

    I've tried assigning the check box to a cell and activating macro's based on the "TRUE", "FALSE" value, but I couldn't get it to work.

    Any help will be very welcome.

    Magic Man
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Hide/unhide based on ComboBox value and CheckBox value
    By Rzzberry in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-31-2017, 11:54 AM
  2. Hide/unhide 2 columns based on checkbox
    By horsefish01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2015, 03:27 AM
  3. Hide/Unhide Rows based on column data using checkbox
    By ricklberry in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2015, 11:39 AM
  4. Hide and Unhide worksheets based on checkbox Tick
    By TwistedFaith in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-14-2015, 01:23 PM
  5. [SOLVED] Hide/unhide Cell contents based on checkbox
    By Kelton in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2014, 04:25 PM
  6. Checkbox macros hide and unhide on another sheet
    By jasonexcels in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2012, 11:13 AM
  7. Hide/Unhide rows with a checkbox on a different sheet
    By blah54 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-15-2012, 11:26 AM

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