Excel "Windows in Taskbar" check box
You could add some code to your personal.xls workbook (assuming you have
one. Press Alt+F11 to open the Visual Basic Editor (VBE). On the left side
of the VBE, look for "VBAProject (personal.xls). If there is a plus sign
(+) next to it, click the plus to expand the Microsoft Excel Objects.
Double-click on "ThisWorkbook".
Paste this code.
Private Sub Workbook_Open()
Application.ShowWindowsInTaskbar = True
End Sub
HTH,
Paul
--
"Joanne" wrote in message
...
Hi
I know to check Tools-Options-Windows in Taskbar in order to display a
separate icon on the taskbar for each Excel file I open. But...I use
Windows
in Taskbar every day and I have to re-check the check box every morning
when
I open Excel. Is there a reason the option does not remain "checked"?
|