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
|