How to Lock Scroll Area in Excel with VBA

There are numerous ways to stop scrolling in excel. In the previous tutorial we talked about preventing scrolling with a much simpler procedure.

Take a look here:    • How To Lock Screen To Prevent Scrolli...  

In This tutorial we are doing the same thing in different way. We are going to use Excel VBA to stop scrolling. Remember I am using Microsoft excel 2010 for the demonstration. Let’s get started.


Support Us:   / excel10tutorial  


Step 1: Click the developer tab. If you don’t find it here is how to get in on the ribbon:    • How to add developer tab in excel  

Step 2: Click on the “Visual Basic”

Step 3: In the new dialogue box click on “Insert”

Step 4: Click “Module”

Step 5: Now write the VBA code. (Please subscribe and here goes the code:   / 34610681  )

Step 6: Click on the “Run”

Done.

You have successfully lock the scroll area in excel and you just prevent scrolling.

#excel10tutorial #lockscroll

Now. In the code you need to write the worksheet name and the scrolling area to make this code work.


Thanks for watching.

If you like this tutorial, please subscribe:
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel: http://bit.ly/2oXmqsb

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Excel VBA Programming Course: http://bit.ly/excelvbacourse

Social media:
Facebook:   / excel10tutorial  
Twitter:   / excel10tutorial  
Blogger: https://excel10tutorial.blogspot.com
Tumblr:   / excel10tutorial  
Instagram:   / excel_10_tutorial  
Hubpages: https://hubpages.com/@excel10tutorial