My users uses a userform to enter data into w/book.but when that w/book
closes,its asking"Do you want to save the changes made to 'Book!.Xls'".,which
my users doesn,t want.
Whenever the userform closes or exits ,automatically it should save changes
without asking the question.
What code I should add to the userform to do the same?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200904/1

Put this in the UserForm code module.

Private Sub UserForm_Deactivate()
ActiveWorkbook.Save
End Sub



"tkraju via OfficeKB.com" <u16627@uwe wrote in message
news:94cd1334acc23@uwe...
My users uses a userform to enter data into w/book.but when that w/book
closes,its asking"Do you want to save the changes made to
'Book!.Xls'".,which
my users doesn,t want.
Whenever the userform closes or exits ,automatically it should save
changes
without asking the question.
What code I should add to the userform to do the same?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200904/1

even after putting this code,its still asking whether to save it or not?

JLGWhiz wrote:
Put this in the UserForm code module.

Private Sub UserForm_Deactivate()
ActiveWorkbook.Save
End Sub

My users uses a userform to enter data into w/book.but when that w/book
closes,its asking"Do you want to save the changes made to
[quoted text clipped - 4 lines]
without asking the question.
What code I should add to the userform to do the same?

--
Message posted via http://www.officekb.com

The there is apparently some automation occuring after the UserForm closes
that the system is detecting. If the file has been saved to the User's
satisfaction at the time they want to close the workbook, then in the
workbook close statement, add
SaveChanges:=False, like this:

ActiveWorkbook.Close SaveChanges:=False

"tkraju via OfficeKB.com" wrote:

even after putting this code,its still asking whether to save it or not?

JLGWhiz wrote:
Put this in the UserForm code module.

Private Sub UserForm_Deactivate()
ActiveWorkbook.Save
End Sub

My users uses a userform to enter data into w/book.but when that w/book
closes,its asking"Do you want to save the changes made to
[quoted text clipped - 4 lines]
without asking the question.
What code I should add to the userform to do the same?

--
Message posted via http://www.officekb.com