View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carim Carim is offline
external usenet poster
 
Posts: 510
Default how to prevent code running when in a worksheet code

Hi Corey,

The easiest solution is to insert a test into your private sub to make
it exit sub if cell A1 = 1 for example else it will execute your code
....

HTH
Cheers
Carim