Auto-save worksheet on close?
Hello!
At work we have a worksheet that is always open. A lot of people are
adding data to the file (on only one computer). But we have a problem;
people are shutting down excel and pressing "no" on the "Do you want to
save changes"-notification.
So;
How could I disable the notification, and instead put on a macro like
this;
Private Sub Worksheet_Close()
Worksheet.Save
End Sub
________________________________
Well, I'm no programmer, so it's surely not right, but how could I
easily do what I want?
Thanks.
Øystein
|