Excel 2016 How To Determine What A Formula Is Doing Excel Macro Tip – Limit The Scroll Area Or Range Movement In An Excel Worksheet

You are searching about Excel 2016 How To Determine What A Formula Is Doing, today we will share with you article about Excel 2016 How To Determine What A Formula Is Doing was compiled and edited by our team from many sources on the internet. Hope this article on the topic Excel 2016 How To Determine What A Formula Is Doing is useful to you.

Excel Macro Tip – Limit The Scroll Area Or Range Movement In An Excel Worksheet

In this article we will explore how to limit the range movement or area that a user can scroll in an Excel worksheet. This is especially useful for a number of reasons that we can explore below.

Prevents users from clicking on areas you don’t want them to click on.

Sometimes, you want to limit the workspace that users can see so that they don’t wander into areas that have no reason to look and click around. These fields may contain formulas or some data that you don’t want the user to see.

Visually you can control how the worksheet looks.

If you create an Excel dashboard, the end result usually looks much better if you can set the bounds of the scroll area.

Help non-experienced users easily navigate around the worksheet.

As of 2007 Excel has a maximum of 1,048,576 rows and 16,384 columns. This is a large area for the user to scroll around and can be lost if they mistakenly press a key to move forward in columns or rows rather than columns or rows.

So back to Excel macros. To help solve all of the above problems we can easily write a small piece of VBA code to preset an area of ​​an Excel worksheet.

How do macros work?

This macro uses the ScrollArea property to set the scroll area for the worksheet you’ve chosen, and allows it to run each time the workbook is opened by placing it in the Workbook_Open event code window. If we don’t put the code in the Workbook_Open event code, it will have to be reset every time the workbook is opened.

So let’s get down to coding.

First. Open Visual Basic – by pressing ALT + F11 or Developer tab – Visual Basic.

Step 1.In the Project window find the name of the project or workbook where you want to place the code.

Step 2. Click on this workbook

Step 3. Select Open Event in the Event drop down list and type or copy the code below – this example limits the scroll area from B2 to L17 of worksheet MM17.

Step 4. Test your macro – the fun bit!

Here is the copy and paste code if you need it. Change your page name and scroll area as needed.

private subworkbook_open()

Sheet(“MM17”).ScrollArea = “B2:L17”

end sub

Video about Excel 2016 How To Determine What A Formula Is Doing

You can see more content about Excel 2016 How To Determine What A Formula Is Doing on our youtube channel: Click Here

Question about Excel 2016 How To Determine What A Formula Is Doing

If you have any questions about Excel 2016 How To Determine What A Formula Is Doing, please let us know, all your questions or suggestions will help us improve in the following articles!

The article Excel 2016 How To Determine What A Formula Is Doing was compiled by me and my team from many sources. If you find the article Excel 2016 How To Determine What A Formula Is Doing helpful to you, please support the team Like or Share!

Rate Articles Excel 2016 How To Determine What A Formula Is Doing

Rate: 4-5 stars
Ratings: 5063
Views: 57977400

Search keywords Excel 2016 How To Determine What A Formula Is Doing

Excel 2016 How To Determine What A Formula Is Doing
way Excel 2016 How To Determine What A Formula Is Doing
tutorial Excel 2016 How To Determine What A Formula Is Doing
Excel 2016 How To Determine What A Formula Is Doing free
#Excel #Macro #Tip #Limit #Scroll #Area #Range #Movement #Excel #Worksheet

Source: https://ezinearticles.com/?Excel-Macro-Tip—Limit-The-Scroll-Area-Or-Range-Movement-In-An-Excel-Worksheet&id=9585345