Unhide Form via Checkbox?

[Bingo969]

Good Morning -

I'm using Excel 2003 and WinXP (Also using Excel 2010 and Windows 7 if there are different approaches but 03/XP is what's used by everyone else currently).

I'm wanting to create an order form workbook. There are a couple of devices that can be ordered which require an additional form to be filled out.

I'd love to have this additional form as a hidden worksheet within that workbook.

So that if they check that box they get a popup saying 'Fill out the security agreement' and the worksheet titled 'Security Agreement' becomes unhidden.

I can do popup boxes and check boxes and all that but never tried unhiding worksheets this way. I found a few similar things via searching these and other areas but nothing quite like this.

Anyone have any suggestions?

Thanks as always for a great resource!!

Bingo

 

[pcc]

put this as the checkbox code

Private Sub CheckBox1_Click()
With Sheets("'Security Agreement")
.Visible = True
.Activate
End With
resp = MsgBox("Please fill out the security agreement", vbExclamation)
End Sub

 

[pcc]

spurious ' in the code sorry should be

Private Sub CheckBox1_Click()
With Sheets("Security Agreement")
.Visible = True
.Activate
End With
resp = MsgBox("Please fill out the security agreement", vbExclamation)
End Sub

 

[Bingo969]

You are outstanding!!

Thank you.