Why does shared workbooks uncheck users Windows in Taskbar option

[Guest]

Every time users go into a shared workbook it unchecks their previously
selected option to show Windows In Taskbar (Tools\Option\View\Windows In
Taskbar). I've tried saving the program with this option checked but it
seems every time I make it a shared workbook and go back into it, this option
unchecks itself. Any way around this?

 

[Dave Peterson]

What version of excel are you running?

Saved from a previous post...

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

 

[Guest]

Thanks Dave, it is Excel 2000.

What version of excel are you running?

Saved from a previous post...

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