I'm quite new to vb for excel, and fairly new to vb. I've written some
subroutines in a workbook that contains multiple worksheets. I'm having quite
a time trying to figure out how to execute my code when the workbook opens,
when the sheet is activated, and when certain cells change in a sheet. I know
how to test for cell changes so that's not a problem - the code is located
behind the worksheet and executes fine. However, I cannot get the code to
excute for the other 2 conditions. I tried putting copies of the code in a
module, and in 'this workbook', and also using worksheet_activate, but cannot
seem to get it to run consistently when it needs to. Any help would be
greatly appreciated.

Thank you

Robert