Inhibit 'Save Changes'

[kirkm]

A project I've nearly finished finally just about everything required
but when you close it Excel asks 'Do you want to save the changes you
made to....' irrespective of whether any changes have been made
or not.

Can I not show this message? Or, even better, only show it when
there have been changes?

Thanks - kirk

 

[Ray]

You can suppress that message with:
Application.DisplayAlerts = False
right before the code to Close the workbook.

I'm sure there's a way to check for changes, but I have no idea how to
code for that ...

//ray

 

[kirkm]

You can suppress that message with:
Application.DisplayAlerts = False
right before the code to Close the workbook.

I'm sure there's a way to check for changes, but I have no idea how to
code for that ...

Ray, I put that into

Private Sub Workbook_BeforeClose(Cancel As Boolean)

but it has no affect there and still brings up the prompt.

Was there where you meant it to go?

Thanks - Kirk