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
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