| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unhiding Check Boxes in Excel 2002
I've got a number of check boxes which are currently hidden in rows 16:19.
How can you automatically unhide them when another check box (which isn't hidden) is selected? I've tried the following code but it objects when it gets to "ActiveSheet.Shapes("CheckBox12").Select": Private Sub CheckBox1_Click() Rows("15:20").Select Range("A20").Activate Selection.EntireRow.Hidden = False ActiveSheet.Shapes("CheckBox12").Select Selection.Visible = True ActiveSheet.Shapes("CheckBox13").Select Selection.Visible = True ActiveSheet.Shapes("CheckBox14").Select Selection.Visible = True ActiveSheet.Shapes("CheckBox15").Select Selection.Visible = True End Sub |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhiding Check Boxes in Excel 2002
Me.CheckBox1.Visible = True
This code is in the worksheet module, right? Me refers to the sheet that owns the code. MWL wrote: I've got a number of check boxes which are currently hidden in rows 16:19. How can you automatically unhide them when another check box (which isn't hidden) is selected? I've tried the following code but it objects when it gets to "ActiveSheet.Shapes("CheckBox12").Select": Private Sub CheckBox1_Click() Rows("15:20").Select Range("A20").Activate Selection.EntireRow.Hidden = False ActiveSheet.Shapes("CheckBox12").Select Selection.Visible = True ActiveSheet.Shapes("CheckBox13").Select Selection.Visible = True ActiveSheet.Shapes("CheckBox14").Select Selection.Visible = True ActiveSheet.Shapes("CheckBox15").Select Selection.Visible = True End Sub -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| migrating check boxes in Excel 2002? | Excel Discussion (Misc queries) | |||
| How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) | |||
| Excel 2002 Will Not Print Text Boxes | Excel Discussion (Misc queries) | |||
| Protection of check boxes in excel 2002 | Excel Discussion (Misc queries) | |||
Linear Mode
