Disabling Mouse Scroll Wheel

[rdavey]

In a given Worksheet, I would like to disable the user's capability to scroll out of the viewable region under any circumstances. In a procedure, have already successfully disabled scroll bars, and any movement keys (Up, Down, Right, Left, PgUp, PgDn, etc). However, I'm still able to scroll up and down out of this region with my mouse scroll wheel. Is there any VBA method to disable this capability as well?

Thanks in advance!

 

[mrmmickle1]

Set the scroll area:

Select the sheet you want the scroll disable to apply to:

Go To: Developer > Properties >ScrollArea

Set Scroll Area = to the range you want the user to reside in. Ex. $A$1:$CM$73

If you have trouble look at this link: CLICK HERE FOR FURTHER INSTRUCTIONS

 

[rdavey]

Absolutely perfect! Thank you very much. I should have figured this out myself...

 

[mrmmickle1]

Your welcome. Glad your issue is solved!

 

[My Aswer Is This]

Learned something new today.