Changing Caption on Taskbar (Excel 2007, Vista)

[AgC]

I am able to change the caption of my Excel app but the caption doesn't appear in the taskbar when the app is minimized, thereby making hard to find if multiple programs are open. Any suggestion?

Thanks,

Steve

 

[Andrew Poulsom]

What have you changed thr Caption to, and what is it when in the Task Bar?

 

[AgC]

I have changed the caption to something custom like "My Workbook"; however, the taskbar only shows the excel logo with no caption.

 

[Andrew Poulsom]

Sorry, I can't reproduce that behaviour (Excel 2003). I used:

Application.Caption = "My Workbook"

 

[AgC]

Sorry, I can't reproduce that behaviour (Excel 2003). I used:

Application.Caption = "My Workbook"

As noted I am using 2007 and I am also using the exact code that you just submitted. The caption is not showing up in my taskbar. Thanks for you help.