Disable Workbook_Activate inside another macro...
 

Hi i need to disable Workbook_Activate when one of y macros run but i can´t
find any way to do it. Can i rename Workbook_Activate to another name? can i
stop it??

Thank´s a lot!!!!

speeD

Disable Workbook_Activate inside another macro...
 

Application.EnableEvents = False

turn it back to true when macro is done.


"SpeeD" wrote in message
...
Hi i need to disable Workbook_Activate when one of y macros run but i
can´t
find any way to do it. Can i rename Workbook_Activate to another name? can
i
stop it??

Thank´s a lot!!!!

speeD

Disable Workbook_Activate inside another macro...
 

Thank´s Bob!

Works great

SpeeD

"Bob Umlas" wrote:

Application.EnableEvents = False

turn it back to true when macro is done.


"SpeeD" wrote in message
...
Hi i need to disable Workbook_Activate when one of y macros run but i
can´t
find any way to do it. Can i rename Workbook_Activate to another name? can
i
stop it??

Thank´s a lot!!!!

speeD