Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've got the following code that does hide the rows indicated, but it
also hides rows where the check box is...as you see I've tried to force the rows it's hiding my mistake to unhide, but that doesn't even work - HELP? Dim chkBox As CheckBox Set chkBox = Worksheets("GTPO_#").CheckBoxes("Check Box 10") If chkBox.Value = xlOn Then 'Sheets("GTPO_#").Select Rows("75:93").Select Selection.EntireRow.Hidden = False Rows("21:30").Select Selection.EntireRow.Hidden = False 'Sheets("GTPO_#").Select ' MsgBox "Check Box is checked" Else 'Sheets("GTPO_#").Select Rows("75:93").Select Selection.EntireRow.Hidden = True Rows("21:30").Select Selection.EntireRow.Hidden = False 'Sheets("GTPO_#").Select ' MsgBox "Check Box is not checked" End If Rows("21:30").Select Selection.EntireRow.Hidden = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLookup is not working correctly | Excel Worksheet Functions | |||
Rows hidden by Autofilter vs hidden by changing the Hidden property | Excel Programming | |||
vlookup isn't working correctly? | Excel Discussion (Misc queries) | |||
This is not working because I didn't write it correctly | Excel Programming | |||
Cursor not working correctly | Excel Discussion (Misc queries) |