Windows in Taskbar

[Guest]

I have noticed a few people have posted regarding this problem but from what
I can see no-one has come up with an answer as yet!

Two users of ours share Excel spreadsheets and it seems that randomly the
"Windows in Taskbar" option keeps on becoming unchecked. This means that they
have to access the different workbooks through the Windows menu which they
don't want to do.

Does anyone know what I can try to resolve this please? So far I have tried
creating a new user profile and updating to Office 2003. Any suggestions (no
matter how ludicrous!) would be greatly appreciated please. Or are we
thinking this is a bug in Excel perhaps?

 

[Dave Peterson]

The only thing that I can remember about the windows in taskbar getting messed
up was with shared workbooks in xl2k (or lower???).

Saved from a previous post...

What version of excel are you running?

There's a bug in xl2k that shows up if you're working with shared workbooks.

If you're not using xl2k and shared workbooks, it sounds like you don't have
permission to save this setting in your windows registry.

I'd talk to my IT folks to find out if they can fix it.

but if you're running xl2k....

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