LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default prevent Excel from popping-up an "OK" (information) message


You can try the following code before start the procedu

Application.ScreenUpdating = false

Do not forget to set it true after finished!

If it does not work, try the "send keys":

send keys "{ENTER}", TRUE

Regards

--
lgarci
-----------------------------------------------------------------------
lgarcia's Profile: http://www.excelforum.com/member.php...nfo&userid=952
View this thread: http://www.excelforum.com/showthread.php?threadid=48025

 
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
"excel "macros may be disabled" message using an xlam file frustrated Excel Worksheet Functions 2 July 13th 09 08:32 PM
Stop the "Personal" sheet from popping up every time I open a work George B Excel Discussion (Misc queries) 2 December 21st 07 10:46 PM
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
"Cannot empty clipboard" message keeps popping up Amy Excel Discussion (Misc queries) 2 March 16th 06 06:52 PM
Prevent "XYZ.doc is locked for editing" message Greg Wilson Excel Programming 2 September 5th 05 09:17 AM


All times are GMT +1. The time now is 09:41 AM.

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"