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.

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" wrote in message
oups.com...
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.

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" wrote in message
oups.com...
| 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.
|