Change the Event to Workbook_SheetChange to Worksheet_Selectionchange.Workbook_sheetchange works only when you change the worksheet. Do let meknow if that helps.