View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pfsardella@yahoo.com.nospam is offline
external usenet poster
 
Posts: 172
Default Excel Macro Help

Avoid message.

Application.DisplayAlerts = False
'Your code here.
Application.DisplayAlerts = True

----------------------------------------------------------------
Clipboard warning.

After the paste,

Application.CutCopyMode - False

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

Gentlemen,


Is there any VBA command that avoid the Message " Do you want
save...... YES NO CANCEL" when I am using the command"
ActiveWindow.Close. This message make my macro be interrupted.


Similar is the message that appear when do a copy and I close the file,
" There is a large amount of information on Clipboard......".
I want to avoid this kind of message.

Thanks

Rubens