Hide or display worksheets based on form
Hi,
Assuming you have a separate checkbox for each sheet the code for each would
look something like this
Private Sub CheckBox1_Click()
If CheckBox1 = True Then
Sheet2.Visible = xlSheetVisible
Else
Sheet2.Visible = xlSheetHidden
End If
End Sub
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"Shawnn" wrote:
Worksheet 1 displays a list of questions. Based on the answer of those
questions (via checkbox), I would like to display different worksheets. For
example the worksheet one is always displayed. If you select yes to question
#1, then worksheet 2 appears. If you select yes to question #2 then
worksheet 3 also appears. Can this be done?
|