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

[Surjya]

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.

[Tom Ogilvy]

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.

--
Regards,
Tom Ogilvy


"Surjya" <[email protected]> wrote in message
news:[email protected]...
> 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.
>

[Jim Rech]

>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.

--
Jim
"Surjya" <[email protected]> wrote in message
news:[email protected]...
| 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.
|