Worksheet Calculate Event

  • Thread starter Thread starter Gustavo
  • Start date Start date
G

Gustavo

Hi everybody,
I need to trigger a macro after I update an autofilter
list. (excel 2000)
I read about the Worksheet Calculate and Worsheet Change
events here and I am using it. The problem is that part of
my macro makes some changes in the worksheet and therefore
it runs in an eternal loop.
Does anybody have a suggestion to solve this problem?
Thanks in advance
Gustavo
 
Thanks Beto....it works great!
Gustavo
-----Original Message-----


Hi, you need to disable the events and then enable them after your macro
is run.

Application.EnableEvents = False
' Your macro goes here
Application.enableEvents = True

--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.

.
Click to expand...
 
Gustavo said:
Hi everybody,
I need to trigger a macro after I update an autofilter
list. (excel 2000)
I read about the Worksheet Calculate and Worsheet Change
events here and I am using it. The problem is that part of
my macro makes some changes in the worksheet and therefore
it runs in an eternal loop.
Does anybody have a suggestion to solve this problem?
Click to expand...

Hi, you need to disable the events and then enable them after your macro
is run.

Application.EnableEvents = False
' Your macro goes here
Application.enableEvents = True
 
Back
Top