Excel 2010 Taskbar Tab

[Chris van der Berg]

When I open more than one worksheet in Excel 2010, only one appears in the taskbar.
My Excel Advanced/Display settings are set a "Show all windows in the taskbar"
Can someone please help !
Regards
Chris

 

[bobhc]

More than one worksheet ??, or more then one work book!!

 

[Chris van der Berg]

Sorry workbook

 

[bobhc]

This is a much discussed problem with Excel, a problem that does not affect Word or Powerpoint.
You could try this

Right click on the taskbar, then choose "Properties", then in the list for "Taskbar Buttons" select "Never combine".


.

 

[Chris van der Berg]

Hi Bobhc,
I checked my "Properties" settings and they are set at "Never combine".
I opened two workbooks but experience the same result.

 

[Chris van der Berg]

Hi Bobhc,

I found a solution at the following link
http://office-tabs.com/download.htm
The software cost $25.00, maybe one of you wise guys can write a VBA code that will give the same result as the software.