Hi
In Excel 2010, under a Workbook_BeforeClose event, I have code to deselect any multiple selection of sheets.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
ActiveSheet.Select 'removes multiple selection of sheets
End Sub
This works fine, when closing an individual spreadsheet...