LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 157
Default Displayalerts and Screenupdating

Hi,

Whats the difference between Application.displayalerts and
Application.screenupdating

1. In which scenarios should I use displayalerts and in which shud I use
screenupdating
2. What is the negative consequence of setting application.displayalerts to
false.
3.If I dont set application.displayalerts to true at the end of the code is
it dangerous or harmful for me?
4. I read help on Screenupdating and it said about it speeds up what the
macro does, though we will not be able to see what the macro does. I want to
know whether it has any bad effect on my coding. Like suppose my macro does
something I didnt intend to do ( I mean If I wrote the code doing an
incorrect operation),would I not get to know as help says that I will not
get to see what the macro does.(Im a absolute novice).

Regards,
Hari
India


 
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
Application.DisplayAlerts in IE scoobydeux Excel Programming 1 April 19th 04 01:28 AM
Can't Set DisplayAlerts to False Mark Driscol Excel Programming 0 April 7th 04 06:11 PM
Can't Set DisplayAlerts to False Mark Driscol Excel Programming 1 April 6th 04 10:45 PM
Can't Set DisplayAlerts to False Mark Driscol Excel Programming 2 April 2nd 04 12:28 PM
application.displayalerts Erin[_5_] Excel Programming 1 December 4th 03 03:49 PM


All times are GMT +1. The time now is 11:58 PM.

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

About Us

"It's about Microsoft Excel"