View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson Myrna Larson is offline
external usenet poster
 
Posts: 863
Default How Can I make excel go faster

Disabling events will only speed up code that uses event handler like the on
change event or such.... If your code does not have any event handlers then
this code will not speed up your procedures


I've often wondered about that. I can envision 2 scenarios:

1. When an event happens, Excel looks for event handlers; if not found, then
"go about it's business"? If that's the case, then perhaps EnableEvents tells
it not to bother looking, and the statement WOULD speed things up.

2. Excel scans your workbook for the presence of event handlers when it first
loads and sets some sort of flag to indicate the result. In that case
EnableEvents would not make a difference, as you say.