View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default Disable running of SelectionChange macro when in another macro?

As ALWAYS post your code for comments. There is rarely a need to select

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tonso" wrote in message
...
Using Excel 2003 I have a macro in a module that automatically deletes
cells. The problem is that as it selects these cells, it activates a
SelectionChange macro. The SelectionChange macro then slows this other
macro down tremendously, even though I have screenupdating off in the
module macro. Is there a way to run the module macro without it
invoking the SelectionChange macro in the sheet?

Thanks