View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mika Mika is offline
external usenet poster
 
Posts: 48
Default disable events does not work

Hi,

I have several public functions in the workbook I am working with, that
are activated or executed whenever I make changes in the worksheets
trough VBA. Although that is not a problem, it is not a good thing as
it is slowing the execution of the VBA code.

My guess is that the changes of the VBA codes into the worksheets,
clear cells, etc, trigger worksheets changes events.

At the beginning of the VBA code I already used:
application.EnableEvents=False to avoid those unnecessary calls to the
public functions but it does not work.

what am I missing ?