Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppressing messages
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Suppressing Blank Rows | Excel Discussion (Misc queries) | |||
Suppressing detail rows | Excel Discussion (Misc queries) | |||
Suppressing screen tips | Excel Discussion (Misc queries) | |||
Suppressing Worksheet Name When Zooming Out | Excel Worksheet Functions | |||
Hi all!! Suppressing the "Do you want to save changes" | Excel Worksheet Functions |