Closing workbook w/o saving changes

[starl]

Have a workbook with a listbox, forms, macros, etc.
Even if you don't actually CHANGE anything, just by activating any of these, the workbook asks if you want to save it when closing.
How can I get around this prompt? I don't want to do an automatic save - what if the user did something and decided they didn't want to save... I just want it to wait for an actual CHANGE before asking

excel97

 

[phantom1975]

You can create a macro in the Workbook_Close event:

Workbook.Saved = True

This won't actually save the workbook. It will just make Excel think that the workbook has been saved.


_________________
Pass on what you have learned. Support this great website by clicking on the sponsor's ads!.
This message was edited by phantom1975 on 2002-09-03 12:27

 

[starl]

But if I do that, it won't prompt even if they actually DID make changes...

 

[phantom1975]

You could do something like this:

Public Flag as Boolean
Private Sub Workbook_Open()
Flag = False
End Sub

Then you can create an IF statement when a legitimate change is made. For instance, if all of your variables are initialized to be "" or 0, then you can do this:

If variable1 <> "" Or variable1 <> 0 Then
Flag = True
End If

Then in the Workbook_Close event you can put this:

If Flag = False Then
Workbook.Saved = True
End If

Does this help?

 

[starl]

yes, it does
thanks