View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Worksheet_Change

Make sure you put it in Worksheet code.
Make sure it only examines a cell on that sheet, not ActiveCell
--
Gary's Student
gsnu200703


"scrimmy" wrote:

I'm using the Worksheet_Change event procedure to call a macro when a certain
cell in the worksheet changes. It seems to work okay, but if I have another
Workbook open, the macro tries to run in that Workbook also. How do I keep
the macro from trying to run in other workbooks that are open?