View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default 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"?