You have pretty well eliminated all your options.

Not on Taskbar.

No CTRL + Tab

No WindowSelect

Where would you like to see the list?

I have an add-in where all my macros are stored. It opens with Excel.

I have this code in Thisworkbook to eliminate the "Microsoft Excel" and
leave just workbook name on Taskbar.

Private Sub Workbook_Open()
Application.Caption = " " 'note space
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.Caption = "" 'note no space
End Sub

You could stick it in your Personal.xls if you have one.

NOTE: when your Taskbar gets too full, all the workbooks will stack under
"Microsoft Office Excel".

You can select using the dropdown arrow.


Gord Dibben MS Excel MVP

On Mon, 18 Jan 2010 15:36:01 -0800, Steven
wrote:


I have a basic issue that I was thinking there may be a programming solution
to.

For example: Lets say I have 5 excel files open. Then I want to change
files and I do not want to hit Ctrl+Tab and cycle through the files....that
gets too hard on my eyes. Then if I click on the Icon on the Task Bar it
does not identify the file that is active and I really do not like the Window
Menu Bar item because it has other stuff on it also.

Does anyone have a solution that is clean, clear and quick to show what
files are open and make selecting the desired file easier?

Also, why on the task bar it cannot somehow identify which file you are in.
Someone told me just look at the file name on the window ... but that is too
much work ... ie (the system should identify better)

Thank you for your help,

Steven