Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 29
Default Disable excel message

May I know what is the code to disable the following excel message:-

"Do you want to replace the contents of the destination cells?"
--
Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,646
Default Disable excel message

Try
Application.DisplayAlerts = False
It is recommended to reset it just after it did its job:
Application.DisplayAlerts = True
Regards,
Stefi


€˛Jaylin€¯ ezt Ć*rta:

May I know what is the code to disable the following excel message:-

"Do you want to replace the contents of the destination cells?"
--
Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******

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
How to disable MS Excel Clipboard message when I run a macro Bon Excel Programming 1 December 15th 05 09:14 AM
Disable Warning Message from Microsoft Outlook in Excel VBA Harvey[_4_] Excel Programming 0 January 19th 05 10:53 AM
Disable Warning Message from Microsoft Outlook in Excel VBA Harvey[_4_] Excel Programming 0 January 19th 05 10:53 AM
Disable Warning Message from Microsoft Outlook in Excel VBA Sarah Excel Programming 2 December 21st 04 03:43 PM
How do I disable 'clipboard' message window in an Excel macro? Jason Griesbach Excel Programming 2 October 19th 04 10:54 PM


All times are GMT +1. The time now is 12:30 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"