Changing The Changed State

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
 
F

Frank Kabel

Hi Greg
normally Excel takes care of this. Do you have any code in the
workbook_BeforeSave event?
 
I

iwrk4dedpr

In the BeforeClose event for the workbook object you can place th
following Me.saved = true


Elsewhere you can put workbooks("NameHere").saved = tru
 
Top