I have a spreadsheet that whenever it is launched, uncheck's the box
"Windows in Taskbar". I re-check the box but it won't stick. The one thing
different about this file is that it is shared. Could that be the cause? Has
any one encounted the same problem?

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

George Tattam wrote:

I have a spreadsheet that whenever it is launched, uncheck's the box
"Windows in Taskbar". I re-check the box but it won't stick. The one thing
different about this file is that it is shared. Could that be the cause? Has
any one encounted the same problem?

--

Dave Peterson

I am running xl2k, so I will try what you suggest. Thanks for your help.


"Dave Peterson" wrote in message
...
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

George Tattam wrote:

I have a spreadsheet that whenever it is launched, uncheck's the box
"Windows in Taskbar". I re-check the box but it won't stick. The one
thing
different about this file is that it is shared. Could that be the cause?
Has
any one encounted the same problem?

--

Dave Peterson