How intercept Column width changed

22 views
Skip to first unread message

typedef

unread,
Apr 20, 2022, 11:31:28 AMApr 20
to Excel-DNA
Hello

How can I  intercept event - Column width changed in C# UDF?

Thanks,

Alex.

Kedar Kulkarni

unread,
Apr 20, 2022, 2:31:24 PMApr 20
to Excel-DNA
I am a bit unsure as to what do you mean by intercept event from a UDF. 

You may be able to show the row width / column height using some volatile functions- check https://www.extendoffice.com/documents/excel/1965-excel-display-row-height-column-width.html

but while excel is calculating formulas, you may not be able to run any event. You could use Aftercalculate event (as a last resort) but it's not a good solution as it fires too many times. 

typedef

unread,
Apr 20, 2022, 4:00:41 PMApr 20
to Excel-DNA
Hello

I am looking where and how I can set event handler on column width changed so I can adjust shapes.

Thanks,

Alex.

Reply all
Reply to author
Forward
Message has been deleted
0 new messages