Detecting Changes to enable a save

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

Hi, I have worksheet and in the beforeclose section I
have told it to save the currentworkbook. Even if someone
first clicks the save icon the systemn still does another
save, is there anyway to see if the sheet has changed
since the last save ? This would enable me to make the
beforeclose a little more intelligent.
 
Hi
try something like the following in your Beforeclose event:

If Not ActiveWorkbook.Saved Then
activeworkbook.save
End If
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Saving a variable value 3
Event after "Save changes?" prompt when exiting 1
Detecting a cancel on Workbook_BeforeClose event? 3
Hide a textbox on open of Excel 3
Notify user macros are disabled. 3
Creating ThisWorkbook Event Procedures 2
Add-In Menu Handling 3
Workbook won't save 3

Back
Top