skipping pop up box for saving changes when closing a file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my macro I open and close several files. One of them I dont want to save
the changes I have done to the file. I thought the following was a way to
elimate the "Do you want to save your changes" pop up box that shows up when
I close the file.....but for some reason excel does not agree with me. Thanks
for the help

Application.DisplayAlerts = False
Workbooks(Top25Report).Close Savechanges:=False
Application.DisplayAlerts = True
 
You must log in or register to reply here.

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

Automatically close file 1
Saving Workbook with Password using SaveChange 2
Message still appears with DisplayAlerts = False & SaveChanges:=Fa 1
Excel crashes on close 2
Close workbook without being prompted to save in VBA 5
Check if file is open, if yes close woorkbook 1
display alerts= false not working 2
save and exit macro 8

Back
Top