Columnwidth changes-Event

T

Tom

Hi

I'm looking for macro that starts each time, when the columnwidth changes.
How to do?

Tom
 
B

Bob Phillips

Tom,

No such event I am afraid.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

Nice idea, but on just playing with it, it doesn't get updated when the
column width is adjusted. If you put
=CELL("width",A1) in A1, you should see a value (8?)
Widen column A, and the value of A1 doesn't change until you re-calculate
(F9). So the calculate event will update it, but not the widening.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top