To Esssa and Gary''s Student...

Better would be to remove the code from the current SelectionChange event
procedure and put it in the workbook's SheetSelectionChange event instead,
then it would apply to every worksheet in the workbook.

To Esssa...

Take the code out of your current SelectionChange event, double click the
ThisWorkbook entry in the Project Window on the left, choose Workbook from
the code window's left hand drop down and SheetSelectionChange from its
right hand drop down an place the code in there.

--
Rick (MVP - Excel)


"Gary''s Student" wrote in message
...
Copy the macro into the worksheet code area of each worksheet.
--
Gary''s Student - gsnu2007k