View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
WOLLAM WOLLAM is offline
external usenet poster
 
Posts: 15
Default Checkbox to Unhide Rows

Hi Per,

Thanks for the input. However, I don't really know what the codesheet is or
how to enter/add anything to it. Any tips?

Thanks,
Dan

"Per Jessen" wrote:

Hi Dan

No extra buttons needed, we tie the macro up to the check box.

As this is an event code it shall be in the codesheet for the sheet where
the checkbox is.
With a Check box named CheckBox1 this macro will unhide rows 1:3 when the
check box is checked. When the check box is unchecked rows 1:3 will be
hidden.

Private Sub CheckBox1_Change()
If Me.CheckBox1.Value = True Then
Rows("1:3").Hidden = False
Else
Rows("1:3").Hidden = True
End If
End Sub

Regards,
Per
"WOLLAM" skrev i meddelelsen
...
Is it possible to use a check box to 'Unhide Rows'? What I would like to
do
is have a client select a check box(es), then press a button I have
inserted
into the spreadsheet to run a macros. This macros would Unhide rows
according to which boxes have been checked. Or is there a way to have
rows
'reveal' or hide themselves as a check box is checked or unchecked, thus
avoiding the need for a macros? My macros skills are OK at best. Thank
you
in advance for any and all help.

Dan