Shared workbook and Windows in taskbar option doesn't work together

[Kert]

Hi,

I have quite a annoying problem with MS Excel 2000. I
have Windows in Taskbar option (Tools->Options->View)
always on, because I have lot of excel files open
concurrently and that helps me to have an overview on
what is opened and what is not. This works fine when I
have no shared workbook opened. But when I open a shared
workbook then Excel automatically cleans Windows in
Taskbar option and shows only a single window in taskbar.
When I reenable Windows in taskbar then it will be
cleared next time when I open a shared workbook.

Has anybody had a similar problem and found a solution to
it?

Thanks in advance,
KERT

 

[Bob Phillips]

Kert,

Not an answer to your question, but it does highlight another problem with
shared workbooks. Excel's shared workbooks do not work well, and I would
advise against using them, they are more trouble than they are worth.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Dave Peterson]

You could use a workbook that reset this option each time you opened/created a
workbook.

If you like this idea:

Start a new workbook
Alt-F11 to get the VBE (where macros live)
hit ctrl-R to see the project explorer (a lot like windows explorer)
select your project (book1) VBAProject
right click and select Insert|Class Module
Paste this in that code window to the right:

Option Explicit
Public WithEvents xlApp As Excel.Application
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


Now doubleclick on the ThisWorkbook object of this same project.
(you might have to expand all the levels to see it)

Paste this in the code window to the right.

Dim myWinInTaskBar As WinInTaskBar
Private Sub Workbook_Open()
Set myWinInTaskBar = New WinInTaskBar
Set myWinInTaskBar.xlApp = Application
End Sub
Private Sub Workbook_Close()
Set myWinInTaskBar.xlApp = Nothing
End Sub

Now back to excel and save your workbook--but save it as an addin and store it
in your XLStart folder.

By saving it as an addin, it'll be invisible to you when you're in excel. By
storing it in XLStart, your addin will load whenever you start excel.

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