Hello All,
In Excel 2007 when you try to close Excel you have to close it twice because your personal workbook is open. I realize this is because I have all windows shown in my taskbar, but that's not a feature I want to give up. I'm trying to find a code I can place in my personal workbook that will make it close excel when it's the only workbook active. The below suggestion is all I've found, but I'm not sure how to execute it.
"Create code for the Workbook.SheetDeactivate Event, that checks if
ActiveWorkbook.Sheets.Count =
(1 or 0, you'll have to play with this to see which works)
Then have it Close the Workbook if it's true."
The concept makes sense to me, but I just don't understand how to make it happen.
Thanks in advance
In Excel 2007 when you try to close Excel you have to close it twice because your personal workbook is open. I realize this is because I have all windows shown in my taskbar, but that's not a feature I want to give up. I'm trying to find a code I can place in my personal workbook that will make it close excel when it's the only workbook active. The below suggestion is all I've found, but I'm not sure how to execute it.
"Create code for the Workbook.SheetDeactivate Event, that checks if
ActiveWorkbook.Sheets.Count =
(1 or 0, you'll have to play with this to see which works)
Then have it Close the Workbook if it's true."
The concept makes sense to me, but I just don't understand how to make it happen.
Thanks in advance
