Have you tried putting you routine in the Worksheet_Activate event?