ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Application.Quit still wants to save (https://www.excelbanter.com/excel-programming/303114-application-quit-still-wants-save.html)

phreud[_23_]

Application.Quit still wants to save
 
I have a close button with the following code:


Code
-------------------
Private Sub btnQuit_Click()
For Each w In Application.Workbooks
w.Saved = True
Next w

Application.Quit
End Su
-------------------


If i fiddle around enough in my UserForm, changing values, I still ge
asked if I want to save changes when I press the quit button. If
don't do alot of changes, it closes allright.

How can the entire workbook just get saved "sometimes"?!?

Thanks!

/ phreu

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 10:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com