Changing The Changed State

  • Thread starter Thread starter Gjones
  • Start date Start date
G

Gjones

Hi;

I was wondering if anyone has a code snippet to show me
how to set the changed state for a workbook to be
changed. I have several routines that create changes to
the workbook but when the user X's out it does not ask
them if they want to save the changes.

Thanks,

Greg
 
Hi Greg
normally Excel takes care of this. Do you have any code in the
workbook_BeforeSave event?
 
In the BeforeClose event for the workbook object you can place th
following Me.saved = true


Elsewhere you can put workbooks("NameHere").saved = tru
 
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

Track Changes Question 1
Problem with "ThisWorkbook.Saved" property. 6
deactivate save changes 1
Strange behavior 3
Unable to change "Enabled" state of an Excel 2007 ribbon gallery b 4
Ribbon visual state gets refreshed when multiple like workbooksopened 1
Import multiple workbooks to current workbook in specified row number 0
Abandoning changes in workbook 12

Back
Top