Hi
I have this checkbox which runs two macros as follows

Private Sub CheckBox1_Click()
If CheckBox1 Then
Yellow
Else
Green
End If
End Sub

Macro 1 is as Follows
Sub Yellow()
'
' Macro1 Macro
'
Range("D4").Select
Range(ActiveCell, ActiveCell.Offset(29, 0)).Select

With Selection.Interior
.ColorIndex = 36
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
End Sub

Question ----------------------------------------------------
How can I in macro1 select those cells immediate below the buttom so that I
can use the same macro with another checkbox?

I also have a password on this worksheet and it appears I want to be able to
unprotect then protect the range at the conclusion. This is confusing for me
because I have two macros [i.e. macro1 and macro2] to consider.

Any assistance would be appreciated.
Regards
Tanya