How do I stop xl2000 asking to save on closing workbook

[Keirie1]

Hi,

How do I stop xl2000's 'Save Yes/No' popping up on closing my workbook.

It only contains data on which I perform searches using a macro. I am not altering anything in the workbook.

The save query only started when I added macros to hide command bars/ toolbars etc. on opening & reinstate them on closing.

I added this in the 'ThisWorkbook' module:

Private Sub Workbook_Close()
With Application
.SaveChanges = False
End With
End Sub

But on joy, any ideas on why it is appearing and how I can stop it would be gratefully appreciated.

Cheers

 

[SIXTH SENSE]

Hi!
try this one insted!

<font face=Courier New><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Workbook_BeforeClose(Cancel <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Boolean</SPAN>)
ThisWorkbook.Saved = <SPAN style="color:#00007F">True</SPAN>
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

 

[Keirie1]

EEEEEeeeeYYYaaaaaa!!!!!

May the Gods smile on you, your children and your children's children

Thank you



and Thanks to all who helped along the way.