Can you hide forms checkboxes based on whether another forms checkbox is selected? If so, where do I need to put the code(Worksheet or Workbook)? Thanks.

Hi Matt

I advise you to use the checkboxes from the control toolbox.
You have much more control then.

You can use this in the Sheet module

Private Sub CheckBox1_Click()
If Me.CheckBox1.Value = True Then
Me.CheckBox2.Visible = False
Else
Me.CheckBox2.Visible = True
End If
End Sub


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Matt" wrote in message ...
Can you hide forms checkboxes based on whether another forms checkbox is selected? If so, where do I need to put the
code(Worksheet or Workbook)? Thanks.

see one more reply to your other post for some forms code.

Matt wrote:

Can you hide forms checkboxes based on whether another forms checkbox is selected? If so, where do I need to put the code(Worksheet or Workbook)? Thanks.

--

Dave Peterson