Use this
Application.DisplayAlerts = False
' your code
Application.DisplayAlerts = True
This will clear the clipboard
Application.CutCopyMode = False
place this line after your paste
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl
"SHIPP" wrote in message ...
I've written a macro that saves an Excel spreadsheet in 2
different formats. Each time I save it the user receives a
message that
1. Do you want to replace the existing spreadsheet.
2. You have a large amount of information. Do you want to
save it for future use.
I would like to suppress both of these messages so that
the user doesn't have to answer them.
How do I do this? Your help is greatly appreciated.