Hi Steve,

can you describe in words what you want to do?

A Workshee_Change event will only fire for the worksheet that it is stored in. If you have a change event in sheet "Mike's Interface" then it will only do something if data is manually entered in that sheet.

I'm afraid I'm not quite clear on what you want changed based on what trigger.

Please explain.