In excel I have a workbook with many sheets. Whenever the workbook is minimized, I'd like to change the width of the minimized title bar so that I can read the whole caption instead of just a few characters (I've made it so the caption conveys important info succinctly).

How do I go about this? I've spent most of today reading up on hooks and subclassing, but am still not sure how to start in VBA? Everything I've read is geard toward VB6.

Any suggestions? Thanks...