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)

"Tom" wrote in message
...
Hi

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

Tom

Is it possible to build a workaround with the CELL("width") formula?




"Bob Phillips" schrieb im Newsbeitrag
...
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)

"Tom" wrote in message
...
Hi

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

Tom

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)

"Tom" wrote in message
...
Is it possible to build a workaround with the CELL("width") formula?




"Bob Phillips" schrieb im Newsbeitrag
...
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)

"Tom" wrote in message
...
Hi

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

Tom