it isn't the version of excel that's the problem, it's the checkbox.
there are two kinds of controls - Forms controls and ActiveX Control
Toolbox controls. the kind you are describing are forms controls.
shane told you that he was using a control toolbox control. at the
top of your spreadsheet right-click and check "control toolbox". that
toolbar will appear. use the checkbox from THAT toolbar.
hope that helps!
:)
susan



On Feb 17, 11:46*am, Adam H wrote:
hiya,

thanks a lot for that but it doent seem to work with the version of excel i
am using, i am using microsoft office excel 2002. do i need to update the
software before being able to do this?? when i right click on the check box,
the only options are cut, copy, paste, edit text, grouping, order, assign
macro, and format control.

Hope this makes it clearer.

Thanks again



"Shane Devenshire" wrote:
Hi,

You only told us how you show the button not how/when to hide it. *Here is
code you would attach to one button to show the other button:

Private Sub CommandButton2_Click()
* * ActiveSheet.Shapes("CommandButton1").Visible = True
End Sub

This is a Control Toolbox button. *CommandButton1 was set to Visible = False
manually and then the code was run.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Adam H" wrote:

Hiya,

I need to set up two check boxes in excel.
The first box needs to be there, on show, all the time, but the second only
needs to appear once the first has been ticked.
Is this possible??

Thanks you for taking the time to read and reply to this,

Adam- Hide quoted text -

- Show quoted text -