Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Rows Using Checkbox
I'd like to hide rows in tab 'Output' based on a checkbox in tab 'Input' ...
I've tried the code below but am getting the Run-time erro 1004 - Select Method of Range class failed. So obviously I'm not calling this correctly. Any help? Thanks. Private Sub checkbox3_Click() If CheckBox3 = True Then Sheets("Output").Select Rows("14:14").Select Selection.EntireRow.Hidden = False End If If CheckBox3 = False Then Sheets("Output").Select Rows("14:14").Select Selection.EntireRow.Hidden = True End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use checkbox to hide rows | Excel Discussion (Misc queries) | |||
Hide & Unhide with a Checkbox | Excel Programming | |||
hide rows from checkbox | Excel Programming | |||
Checkbox to hide and unhide rows Please. | Excel Worksheet Functions | |||
Checkbox to hide or show rows | Excel Programming |