Hi all
I have a command button that closes the active workbook and activates another workbook that is already open....
Private Sub CommandButton1_Click()
ActiveWorkbook.Close
Windows("Database.xls").Activate
End Sub
When this button is clicked the user may be asked if they wish to save changes. I dont want them too.
Is it possible for a worksheet to NOT ask "Do you wish to save changes?" when it is closed (i.e when this command button is clicked)?? and only save changes when they File-Save.....
Thanks for your time.
I have a command button that closes the active workbook and activates another workbook that is already open....
Private Sub CommandButton1_Click()
ActiveWorkbook.Close
Windows("Database.xls").Activate
End Sub
When this button is clicked the user may be asked if they wish to save changes. I dont want them too.
Is it possible for a worksheet to NOT ask "Do you wish to save changes?" when it is closed (i.e when this command button is clicked)?? and only save changes when they File-Save.....
Thanks for your time.