ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Columns resize event (https://www.excelbanter.com/excel-programming/343144-columns-resize-event.html)

mihaij

Columns resize event
 

Hello there,

I need to handle the columns resize operation in an Excel Worksheet bu
I don't know what event is generated when the column is resized (usin
mouse drag) and how to capture this event in the VBA code of the Exce
document.
Any help is apreciated.

miha

--
mihai
-----------------------------------------------------------------------
mihaij's Profile: http://www.excelforum.com/member.php...fo&userid=2819
View this thread: http://www.excelforum.com/showthread.php?threadid=47722


Chip Pearson

Columns resize event
 
No event is raised when you change the width of columns. There is
no way to catch that action in VBA.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"mihaij"
wrote in message
...

Hello there,

I need to handle the columns resize operation in an Excel
Worksheet but
I don't know what event is generated when the column is resized
(using
mouse drag) and how to capture this event in the VBA code of
the Excel
document.
Any help is apreciated.

mihai


--
mihaij
------------------------------------------------------------------------
mihaij's Profile:
http://www.excelforum.com/member.php...o&userid=28190
View this thread:
http://www.excelforum.com/showthread...hreadid=477227





All times are GMT +1. The time now is 05:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com