PC Review


Reply
Thread Tools Rate Thread

Disable Workbook_Activate inside another macro...

 
 
SpeeD
Guest
Posts: n/a
 
      20th Feb 2009
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 With Quote
 
 
 
 
Bob Umlas
Guest
Posts: n/a
 
      20th Feb 2009
Application.EnableEvents = False

turn it back to true when macro is done.


"SpeeD" <(E-Mail Removed)> wrote in message
news:EB7A6A1D-C907-43AF-BC89-(E-Mail Removed)...
> 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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Workbook_Activate() vs Workbook_Open() Robert Crandal Microsoft Excel Programming 1 21st Nov 2009 12:51 AM
External_ workbook_activate() or workbook_activate()? =?Utf-8?B?Y2xhcmE=?= Microsoft Excel Programming 0 23rd Mar 2007 05:38 PM
Workbook_Activate not triggered by Alt+Tab Antoun Microsoft Excel Programming 17 8th Mar 2007 03:25 PM
using a cell value to control a counter inside a macro and displaying macro value ocset Microsoft Excel Worksheet Functions 0 9th Sep 2006 12:36 AM
Workbook_Activate question =?Utf-8?B?UGV0ZXIgUm9vbmV5?= Microsoft Excel Programming 4 17th Nov 2005 10:18 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:21 PM.