View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default How to disable all Excel Events and then re-activate them?

Hi all,

I have an .xls file in Excel 2002 format, in which it is used as a sort of
template in my group and then when new data is loaded onto it, it is saved
into under another name. It has two event calls in it:

SheetActivate()
SheetSelectionChange()

But I need to disable them load the new data in and then re-enable them. Is
there a way of doing this? Thanks for sharing your thoughts.


Ben

--