Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default Command to prevent "event" macros from firing

I know there is a command for preventing "event" macros from running you can
set to "False" then switch back to "true" at the end of the macro to
re-enable, but I can't remember the command itself....!!!!!

Can someone please help me out with this command name?

Thanks much in advance...
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,117
Default Command to prevent "event" macros from firing

Application.EnableEvents = False

:)
susan


On Jul 15, 11:34*am, XP wrote:
I know there is a command for preventing "event" macros from running you can
set to "False" then switch back to "true" at the end of the macro to
re-enable, but I can't remember the command itself....!!!!!

Can someone please help me out with this command name?

Thanks much in advance...


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
ie Command to Wait for "File Download" and "Save As" windows [email protected] Excel Programming 11 April 24th 08 11:20 AM
In Excel 2003 is there a way to prevent "Save As" and "Print"? lucky2000 Excel Discussion (Misc queries) 3 April 26th 07 02:49 PM
inserting a conditional "go to" command on a excel "if" function velasques Excel Worksheet Functions 5 March 10th 06 08:16 PM
Prevent "standard" key event in userform Oskar[_2_] Excel Programming 5 May 30th 04 12:51 PM
Prevent "standard" key event in userform Harald Staff Excel Programming 0 May 28th 04 11:36 PM


All times are GMT +1. The time now is 10:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"