[RESOLVED] Suppressing the Save Prompt on file close

[Legolad]

Hi folks,
I have created a little tool in a standalone Excel file (no db connections or anything).

The tool has 2 ListBox controls. When the workbook opens, I populate ListBox1.
When the user clicks a value in ListBox1, I populate ListBox2 with the Items related to the user's selection.
I keep the workbook protected (except for one cell that I use to store a variable for as long as the work book is open).
This all works fine.

I have only one issue now.
I've noticed that when I am done using the tool and I close the workbook, Excel prompts me to save the file. I don't ever want anyone to save any changes to this file. It is for reference purposes only.

I've tried returning all the controls (and that one unprotected cell) to their initial state, but I still get the save prompt.

I've tried setting DisplayAlerts to False in the BeforeClose event, but it had no effect.

I do not want to close the workbook from code.
I cannot close the app because the user may have other workbooks open.
I just want to suppress the Save prompt when the user closes the tool.

I've been searching here and elsewhere but cannot seem to find a solution.

Any ideas?

[westconn1]

you can try

in the before close event
thisworkbook.saved = true

[Legolad]

Sweet Success!


That did the trick.


Thanks so much.