Ron Can that .Value=0 be in any cell i choose
yes you can choose the cell

You can disable events like this also
Application.EnableEvents = False




--
Regards Ron de Bruin
http://www.rondebruin.nl


"Simon Lloyd " wrote in message ...
Ron Can that .Value=0 be in any cell i choose, need the code to be
disabled because i have a lot of worksheet selection_change code so
when on the spread sheet you try to drag and select rows and or columns
the events try to take place and crash the program thats why i need to
add a button to the menubar that turns of this code until pressed
again!

Simon


---
Message posted from http://www.ExcelForum.com/