| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Supress Confirmation Prompt
I am trying to surpress a Save confirmation prompt in Excel 2002 and have
tried using the line Application.DisplayAlerts = False It is not working. Any suggestions will be appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Supress Confirmation Prompt
If you want to close the file without saving, you could use this before
closing it: Workbooks("Test.xls").Saved = True - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "PA" wrote in message ... I am trying to surpress a Save confirmation prompt in Excel 2002 and have tried using the line Application.DisplayAlerts = False It is not working. Any suggestions will be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Confirmation box | Excel Programming | |||
| Confirmation ID provided? | New Users to Excel | |||
| supress prompt for named ranges when copying sheet to new workbook | Excel Programming | |||
| Getting rid of confirmation boxes | New Users to Excel | |||
| How to supress a Save prompt? | Excel Programming | |||
Linear Mode
