PDA

Click to See Complete Forum and Search --> : hook or subclass window properties in excel?


jrock2468
Aug 8th, 2005, 02:41 PM
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...