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
|