How to Lock Scroll Area in Excel with VBA
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
Смотрите видео How to Lock Scroll Area in Excel with VBA онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Excel 10 tutorial 25 Ноябрь 2017, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 14,612 раз и оно понравилось 108 людям.