Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Catch column width event.

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default Catch column width event.

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 162
Default Catch column width event.

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Catch _AfterSave Event & Saved Property Problem ... Joe HM Excel Programming 7 March 17th 05 11:30 AM
How do I 'catch' a 'delete cells' event Eric Excel Discussion (Misc queries) 2 March 9th 05 07:22 PM
Catch drop event in excel Edi Excel Programming 1 February 20th 05 05:26 PM
Catch Update Linked Cells Event Joe[_23_] Excel Programming 1 August 14th 03 02:39 PM


All times are GMT +1. The time now is 03:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"