[RESOLVED] [Excel] How to auto reply msgboxes?

Hi All

I have made a userform at work that shows up when I open my workbook and shutdown when I close. When I close the workbook Excel has an auto msgbox that ask if I wanna save the document but I dont want my collegues to have this option.

So my question is:

Is it posible to make my macro auto reply excels auto msgboxes? or is there an other way to avoid this problem?

Regards

Master_A

Quote:

---

Is it posible to make my macro auto reply excels auto msgboxes? or is there an other way to avoid this problem?

---

yes
from your userform you can use thisworkbook.saved = true either deliberately on a button click or something, or the Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)

Thanks that solved it