+ Reply to Thread
Results 1 to 11 of 11

Hide multiple checkboxes when a row is hidden

Hybrid View

  1. #1
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Hide multiple checkboxes when a row is hidden

    It might be best to try unhiding/hiding them before you hide the columns. It seems you can get it to work providing that you have them set up in precisely the right location, it should be more forgiving the other way:

    Sub tres()
    '
    ' tres Macro
    ' 3
    '
    ' Keyboard Shortcut: Ctrl+t
    '
    Dim chkbx
        Columns("A:H").Hidden = False
    For Each chkbx In ActiveSheet.CheckBoxes
        chkbx.Visible = False
    Next chkbx
    Call hide_unhide_checkboxes(4)
    Call hide_unhide_checkboxes(5)
    Call hide_unhide_checkboxes(7)
    Call hide_unhide_checkboxes(8)
    Range("D1:E1,G1:H1").EntireColumn.Hidden = True
    
    End Sub
    Sub cuatro()
    '
    ' cuatro Macro
    ' 4
    '
    ' Keyboard Shortcut: Ctrl+c
    '
    Dim chkbx
        Columns("A:H").Hidden = False
    For Each chkbx In ActiveSheet.CheckBoxes
        chkbx.Visible = False
    Next chkbx
    Call hide_unhide_checkboxes(4)
    Call hide_unhide_checkboxes(5)
    Call hide_unhide_checkboxes(6)
    Call hide_unhide_checkboxes(8)
    Range("D1,F1:H1").EntireColumn.Hidden = True
    
    End Sub
    Sub pat()
    '
    ' pat Macro
    ' 5
    '
    ' Keyboard Shortcut: Ctrl+p
    '
    Dim chkbx
        Columns("A:H").Hidden = False
    For Each chkbx In ActiveSheet.CheckBoxes
        chkbx.Visible = False
    Next chkbx
    Call hide_unhide_checkboxes(4)
    Call hide_unhide_checkboxes(5)
    Call hide_unhide_checkboxes(6)
    Call hide_unhide_checkboxes(7)
    Range("D1:G1").EntireColumn.Hidden = True
    
    End Sub
    Sub uno()
    '
    ' uno Macro
    ' uno
    '
    ' Keyboard Shortcut: Ctrl+u
    '
    Dim chkbx
        Columns("A:H").Hidden = False
    For Each chkbx In ActiveSheet.CheckBoxes
        chkbx.Visible = False
    Next chkbx
    Call hide_unhide_checkboxes(5)
    Call hide_unhide_checkboxes(6)
    Call hide_unhide_checkboxes(7)
    Call hide_unhide_checkboxes(8)
    Range("E1:H1").EntireColumn.Hidden = True
    
    End Sub
    Sub dos()
    '
    ' dos Macro
    ' 2
    '
    ' Keyboard Shortcut: Ctrl+d
    '
    Dim chkbx
        Columns("A:H").Hidden = False
    For Each chkbx In ActiveSheet.CheckBoxes
        chkbx.Visible = False
    Next chkbx
    Call hide_unhide_checkboxes(4)
    Call hide_unhide_checkboxes(6)
    Call hide_unhide_checkboxes(7)
    Call hide_unhide_checkboxes(8)
    Range("D1,F1:H1").EntireColumn.Hidden = True
    End Sub
    Sub hide_unhide_checkboxes(col_num As Integer)
    Dim chkbx
    For Each chkbx In ActiveSheet.CheckBoxes
        If chkbx.TopLeftCell.Column = col_num Then chkbx.Visible = False Else chkbx.Visible = True
    Next
    End Sub

  2. #2
    Registered User
    Join Date
    09-06-2013
    Location
    santiago
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Hide multiple checkboxes when a row is hidden

    can't get it going...it doesn't seem to have chenged from the previous code, checkboxes covering each other ...for some reason some checkboxes appear in the column I (9), i don't understand why.
    Last edited by daniva92; 09-09-2013 at 01:52 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hide a many checkboxes when the column is hidden
    By Gruberj01 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-11-2013, 06:15 AM
  2. need macro to hide/unhide columns through multiple checkboxes
    By trier in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2013, 04:00 PM
  3. Show/Hide Range of Cells Using Multiple Checkboxes
    By rdacso in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-21-2013, 02:06 PM
  4. Using multiple checkboxes as an index page to hide/unhide worksheets
    By Damien_Lee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2013, 07:24 AM
  5. Hide/Unhide Multiple Checkboxes
    By LampCommandr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2011, 09:35 AM

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