Excel "Windows in Taskbar" check box

[Joanne]

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"?

 

[PCLIVE]

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

 

[Dave Peterson]

Do you use xl2k?

Are you working with shared workbooks?

There's a bug (fixed in xl2002) that changed that setting under certain
conditions.

Saved from a previous post:

Is the workbook shared? (A bug in xl2k turns it off for shared workbooks.)

You could create a new workbook saved into XLStart (or put this into your
personal.xls workbook) and it'll toggle that option each time you open a
workbook.

In the ThisWorkbook module:

Option Explicit
Public WithEvents xlApp As Excel.Application
Private Sub Workbook_Open()
Set xlApp = Application
End Sub
Private Sub Workbook_Close()
Set xlApp = Nothing
End Sub
Private Sub xlApp_NewWorkbook(ByVal Wb As Workbook)
Application.ShowWindowsInTaskbar = True
End Sub
Private Sub xlApp_WorkbookOpen(ByVal Wb As Workbook)
Application.ShowWindowsInTaskbar = True
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Joanne]

thank you Dave & PCLIVE - I will try using a macro and report back.

It IS Excel 2000 - no choice there, my employer has not elected to upgrade
<heavy sigh>. I do have one shared workbook but it is not opened every day.
I have some familiarity with macros, just no time to learn to use VBA
extensively.