Thread: Hide rows with checkbox
View Single Post
 
Old 03-23-2015, 02:16 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default Hide rows with checkbox
OK...so I have a form with several rows that I would like to hide/show based on the value of a checkbox. There are some other checkboxes in this are that I want to hide with the rows that they are on. However, when I go to the Format Control: Properties, the Move and Size with cells option is grayed out. Any idea why that's happening?

Also, here is the macro...

Code:
Private Sub cbClaimHide_Click()
  If cbClaimHide = True Then
    [47:53].EntireRow.Hidden = True
    Else: [47:53].EntireRow.Hidden = False
  End If
End Sub
Regardless of whether it is checked or not, it always goes to else. What the heck have I screwed up?
Reply With Quote