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.

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.