Thank you so so much for this video, it worked very well and it was very easy to follow the steps. I appreciate the screen recording since my excel is not in English so I was able to follow the steps without trying to translate the buttons.
Hi there, I followed your example and added the macros and lock my Worksheet. The scrolling is stopped on my sheet from left to right but my sheet does extend down below quite a ways and when I get to the bottom I am still able to scroll past my data. Is there a reason it is not stopping the top to bottom scroll? Hopefully, you will see this comment seeing that this post is over 7 months old now. Fingers crossed. Thanks.