C
Corey
I currently use:
Sub Button14_Click()
Application.DisplayAlerts = Fasle
ActiveWorkbook.Save
ActiveWorkbook.Close
Application.DisplayAlerts = True
End Sub
Is there a way for Excel to Check if ANY other Workbooks are Open or Not.
If NO others are Opened, then to QUIT rather than to CLOSE ???
But if there is another Workbook open then Excel simply Closes this Workbook
an NOT Quitting Excel.
Can you do this?
Corey....
Sub Button14_Click()
Application.DisplayAlerts = Fasle
ActiveWorkbook.Save
ActiveWorkbook.Close
Application.DisplayAlerts = True
End Sub
Is there a way for Excel to Check if ANY other Workbooks are Open or Not.
If NO others are Opened, then to QUIT rather than to CLOSE ???
But if there is another Workbook open then Excel simply Closes this Workbook
an NOT Quitting Excel.
Can you do this?
Corey....