[URGENT] How to Trap Excel Window Scroll Events in VSTO

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Surjya - 24 Jan 2006 15:45 GMT

Hi all,

Does anybody have any idea about how to trap the window scroll-bar
events and mouse scroll events for an excel sheet through VSTO?
We can also make do with any events related to change of visible range.

We are in real soup now. Any little help will be appreciated

Thanks in advance
~Surjya.

Reply to this Message

Tom Ogilvy - 24 Jan 2006 15:50 GMT

there are no built in events associated with any of what you describe. If
you want that type of control, my guess would be you would need to subclass
excel.

A workaround might be to use the selectionchange event, but the user can
scroll and not select and not trigger that event.

Signature

Regards,
Tom Ogilvy

> Hi all,
>
[quoted text clipped - 6 lines]
> Thanks in advance
> ~Surjya.

Reply to this Message

Jim Rech - 24 Jan 2006 15:55 GMT

>how to trap the window scroll-bar events and mouse scroll events for an
>excel sheet

There are no such events, at least none exposed by Excel. I think you'd
have to check the visible range periodically.

Signature

Jim

| Hi all,
|
[quoted text clipped - 6 lines]
| Thanks in advance
| ~Surjya.

Reply to this Message