Excel open files on task bar

[Steven]

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

 

[Bob Phillips]

That works fine for me, although you don't need the =

=COUNTIFS('Policy Log'!D3300, "Case Mgmt.", 'Policy Log'!E3:E300,
"Active")

This is an Excel 2007/2010 specific function, if you have Excel 2003 use

=SUMPRODUCT(--('Policy Log'!D3300="Case Mgmt."),--('Policy
Log'!E3:E300,="Active"))

HTH

Bob

 

[Steven]

Bob,

Were you answering this post? If so, I dont follow.

Thanks,

Steven

 

[Gord Dibben]

You have pretty well eliminated all your options.

Not on Taskbar.

No CTRL + Tab

No Window>Select

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

 

[Steven]

Gord,

That is helpful. It is nice not to see the redundant .xls which just makes
it harder to read. I think I would be happy if when you click on the taskbar
Icon it would indicate which window you are in.

Thank you for your idea, it definitely is an improvement,

Steven

 

[Steven]

I think I misunderstood. What I thought it was doing is not actually. I
guess I am back to thinking that when the files show from the taskbar it
should identify which window the user is in.

Thanks

 

[Bob Phillips]

Steven,

I was answering A post, you can see that from the detailed level of my
answer, but it clearly wasn't this one. I wonder what happened there <g>

Bob