Supress Confirmation Prompt

P

PA

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.
 
J

Jon Peltier

If you want to close the file without saving, you could use this before
closing it:

Workbooks("Test.xls").Saved = True

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save workbook without shapes 0
Outlook 365 delete confirmation not working even though the option is selected 1
Word 97 Password 0
Pop up requires me to confirm password to allow email to be received 0
Word macro that can call cells out of Excel for a find and replace 0
Removing confirmation POP from excel 4
how to close Read Only file without prompt to save copy 3
WORD VBA Search and switch to advanced ... 1

Top