Columnwidth changes-Event

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Hi

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

Tom
 
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)
 
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)
 
Back
Top