View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kAVAL kAVAL is offline
external usenet poster
 
Posts: 2
Default Suspending MAcros

I am using a Worksheet_Change macro to update several
cells when a change is made in a specific range.

When the macro changes the other cells it then starts the
Worksheet_Change routine again and I end up with an
endless loop.

Is there an easy way to temporarily suspend the
Worksheet_Change macro while cells are updated and then
re-enable?

Kaval