Tom I have tried yours but it will not allow both together as an erro
occurs stating ambigious error detected as CheckBox1_Click is alread
being used. I want to use both of your programs that you have create
for the checkbox. Do you know how?

Thanks;)

Tom Ogilvy Wrote:
If you want them hidden when the checkbox is checked and unhidden whe
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 i
unchecked.
This is really frustrating me as I have tried to write a progra
using
boolean instead of the macro for when the button is "clicked" an
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



--
Sa
-----------------------------------------------------------------------
Saz's Profile: http://www.excelforum.com/member.php...fo&userid=1722
View this thread: http://www.excelforum.com/showthread.php?threadid=54946