Hi All,
I have a question to which I hope the answer isn't painfully obvious to
anyone who is not an amatuer as myself.

I'm using the SheetChange property for my workbook as discussed in other
threads here and I'm trying to use it on a non-active worksheet.

I have a combo box with "Yes" or "No" as the available selections that is
linked to a cell on a seperate "tables" sheet. I am currently using the
SheetChange sub to monitor the changes to this linked cell and run a few
basic IF statements when they are indeed changed. The code works perfectly
when the "tables" sheet is active, but it will not run if the cell is changed
through the combo box on the "main" sheet.
Is there a way to have the WorksheetChange run even when a worksheet is not
active?

Thanks in advance to anyone who might offer a little advice!
--
cmungs