For the last part of your question
You can trigger a macro upon sheet activation
http://www.mvps.org/dmcritchie/excel/event.htm
look for Worksheet_Activate

The first part you indicated the checkmark is on a form, so
don't have an answer for you. If on a worksheet it would
be a change event and you would test the value.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"mav93" wrote in message
...

Bob

Thanks a lot for the code, there are a couple of problems though

Two of the cells that trigger the macro are linked to check boxes

J3 is linked to forms check box 83
K3 is linked to forms check box 86

I'm not sure what to tell you the problem is but I do know that when I
manually typed in true or false (refering to whether or not the check
box was checked) into J3 or K3 your code worked great. So i'm assuming
that the checking the check boxes does't actually cause J3 or K3 to
change.

I'm not sure how to make the checking a forms check box a change
event?

Also, is there a way to trigger the macro each time the I enter the
sheet?

Thanks agin for any help


--
mav93
------------------------------------------------------------------------
mav93's Profile: http://www.excelforum.com/member.php...o&userid=31592
View this thread: http://www.excelforum.com/showthread...hreadid=516220