| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with Workbook_Activate event | Excel Programming | |||
| Workbook_Activate not triggered by Alt+Tab | Excel Programming | |||
| Lost clipboard contents on Workbook_Activate | Excel Programming | |||
| VBA - Disable up down movement inside ListBox | Excel Programming | |||
| Workbook_Activate question | Excel Programming | |||
Linear Mode
