Hi,

I am using a check box and sending the true or false value to another
spreadsheet (at cell A2), I am then using the following code:

If Target.Address = "$A$2" Then
If UCase(Target.Value) = "FALSE" Then
Rows("5:56").Hidden = True
Else
Rows("5:56").Hidden = False
End If
End If

this code does not work using the check box to send a true or false value,
it does however work when I manually type in false or true.....???

Can any one help me with this one?

Thank you guys in advance,

TG