Hello,

I am a newbie to the programing side of Excel and would
like to ues a check box (forms version) to give a second
option for a standard calcultion sheet. Under the first
option it requires just one row. For the second it would
require an additional 3 rows. I would like to hide the
additional 3 rows if the default calc is being made. So
they would be unhiden under once the check box is check
and the second calculation is being perfomed.

I have used the following code...

Private Sub MechCheck_Change()
If MechCheck.Value Then
Sheets("Main").Range("ExtraRows").EntireRow.Hidden
= False
Else
Sheets("Main").Range("ExtraRows").EntireRow.Hidden
= True
End If
End Sub

with MechCheck the name of my checkbox, Main being the
sheet name and ExtraRows the name of rows to be hidden.

When I check the box in excel, my first problem is that I
get an error which indicates the macro can not be found.
Secondly, within the VB editor the second line is
highlighted yellow and it has a run time error '424' and
says Object Required.

Can anyone point me in the direction of my error?

many thanks!
-Anton