View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default Where to place code that changes a cell value?

Hi George,

I would like the code to execute if the value of any cell changes, but I do
not want to copy the code to more than one location. I.E only one place to
update the code if maintenance is needed.


IN that case you need the Workbook_SheetSelectionChange event in the
Thisworkbook module.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com