You left out part of your macro, specifically which event are you using!
However, as changing an object is not detected by events, I don't think you
are heading in the right direction. Perhaps you could use the
worksheet_Activate event, and then have it check range "a2" of the
appropriate sheet and decide whether to hide the rows or not.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"TG" wrote:

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