Dani's Middleware

http://office.microsoft.com/en-us/excel-help/compare-cell-contents-HP003056130.aspx#BMcompare_one_value_to_a_list_of_values =OR(EXACT(B2, A2:A4)) also works with  AND

Name the macro: Auto_open() Sub Auto_open() End Sub Auto_close() will also work.