Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,everybody.
I try to add excel to my mfc dialog application. I want only one - to catch event when user change width of column. How can i do it, which event i should catch?Is it possible? P.S. As i understand,there is two ways to add excel to my application. First is to add ActiveX control to dialog form. Second to import type library and run excel. But on second way i can't kill all toolbars and make Excel to be child of my dialog (i.e repeate view like on first way),is it posible? P.P.S Please answer with sample code or link to any article. Thank you. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Unfortunately a change of column width does not trigger an event, so there
is no direct solution. Further, format changes in general do not trigger events. If it's really important for you to monitor, maybe store all column widths in a 1 to 256 array, an array of the width of the used range, or just those columns you are interested in. In subsequent sheet or selection change events compare differences in actual and stored widths. Any change in width(s) would have been done prior to the event you are trapping. I don't follow what you are asking in your PS's. Sound like separate questions which might be worth restating in a new thread. Regards, Peter T "Artem Omelianchuk" wrote in message ... Hello,everybody. I try to add excel to my mfc dialog application. I want only one - to catch event when user change width of column. How can i do it, which event i should catch?Is it possible? P.S. As i understand,there is two ways to add excel to my application. First is to add ActiveX control to dialog form. Second to import type library and run excel. But on second way i can't kill all toolbars and make Excel to be child of my dialog (i.e repeate view like on first way),is it posible? P.P.S Please answer with sample code or link to any article. Thank you. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If you're using MFC, I would add the ActiveX control and use an
asynchronous timer to poll the column widths and raise your own event. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Catch _AfterSave Event & Saved Property Problem ... | Excel Programming | |||
How do I 'catch' a 'delete cells' event | Excel Discussion (Misc queries) | |||
Catch drop event in excel | Excel Programming | |||
Catch Update Linked Cells Event | Excel Programming |