ExcelBanter - "Windows in Taskbar" setting is lost everytime I close XL

Do you work with shared workbooks?

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

===================
If none of your workbooks are shared, then it sounds like you don't have
permission to save that setting in the windows registry.

yerk55 wrote:

This is Excel 2000 running on XP Pro SP2.

I want my excel docs to each have their own taskbar button instead
sharing one single one.

If I go to Tools, Options, View tab and check the checkbox for "Windows
in Taskbar" and click OK, it changes the behavior to exactly how I
want.

However, as soon as I close Excel, this setting is lost. If I close
Excel, immediately reopen it, and go back to that checkbox, it's
unchecked again. Why on earth won't it stick longer than one Excel
session?

Any ideas would be greatly appreciated.

TIA

--

Dave Peterson