this is a continuation of this POST:

so what i am looking for is the following:

Use the worksheet open event to scan the sheet "Closed POs" and look for expired dates (anything more than a month) in column D.

i already have the code for the change event and that works. what is needed now is the above.

can anyone help me out with this?