View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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