application.enableevents=false
'do stuff here
application.enableevents=true

that should do it....

--
www.alignment-systems.com


"Ben" wrote:

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

--