Windows in taskbar

  • Thread starter Thread starter George Tattam
  • Start date Start date
G

George Tattam

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
 
I am running xl2k, so I will try what you suggest. Thanks for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top