How do I set up a macro to turn on Windows in Taskbar in Excel 200

[David Lee - NZ]

I have a shared workbook in Excel 2000 that is automatically turning off
Windows in Taskbar whenver it is opened and I can't see why. Does anyone out
there know a macro that will automatically turn on the Windows in Taskbar
option in Excel when the workbook is opened?

Thanks
David Lee

 

[Charles Maxson]

David

Add the following line code to an Autpen or Workbook_Open event:

Application.ShowWindowsInTaskbar = True

*pretty sure that was in Office 2000, I am in 2003 so I wasn't able to
check...

 

[Dave Peterson]

Is the workbook shared? (A bug in xl2k turns it off for shared workbooks.)

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