If you want them hidden when the checkbox is checked and unhidden when it is
unchecked then
Private Sub CheckBox1_Click()
Set rng = Sheets("Sheet1").Rows("13:22")
rng.Hidden = CheckBox1.Value
End Sub
for the opposite:
Private Sub CheckBox1_Click()
Set rng = Sheets("Sheet1").Rows("13:22")
rng.Hidden = Not CheckBox1.Value
End Sub
--
Regards,
Tom Ogilvy
"Saz" wrote:
>
> Help!
> I am creating a workbook where in worksheet1 there is a checklist.
> Ideally when a topic's checkbox is clicked, a macro (which I have
> assigned) will hide certain rows on worksheet2.
> However I cannot get the action to reverse when the box is unchecked.
> This is really frustrating me as I have tried to write a program using
> boolean instead of the macro for when the button is "clicked" and then
> clicked again, but I am not getting anywhere.
>
> If it helps the rows I have also grouped into arrays.
>
> Below is like my 20th attempt
>
> Private Sub CheckBox1_Click()
> Sheets("Sheet1").Select
> i = Rows("13:22")
> i.Select
> Selection.EntireRow.Hidden = True
> Sheets("Sheet2").Select
>
> End Sub
>
>
> --
> Saz
> ------------------------------------------------------------------------
> Saz's Profile: http://www.excelforum.com/member.php...o&userid=17226
> View this thread: http://www.excelforum.com/showthread...hreadid=549468
>
>
Bookmarks