VBA To replace Mousewheel Scroll Event to go down or up one row isntead of 3

[Bill Bisco]

Dear all,

I want to write VBA Code that will replace the Regular Mousewheel Scroll Event and go up or down 1 row instead of whatever the Windows Mouswheel Scroll settings are


This is the code to Scroll down or up<code> </code><code>ActiveWindow.SmallScroll down:=1
<code>ActiveWindow.SmallScroll up:=1

What VBA Code would I use to modify the OnScroll event?

Thanks,

Bill</code></code>

 

[KeepTrying]

This update should restrict the code to the calling workbook only :
.....

Amazing, thanks for sharing