In this Microsoft Excel video tutorial, I explain how to set the scroll area of a worksheet. Setting a scrollable area will limit the scrollable and viewable area of a worksheet. To permanently set the scroll area of a worksheet, it is necessary to use a VBA macro. The code for this macro is included in the downloadable fill. With a VBA macro, the scroll box can be set automatically when a worksheet is activated or the VBA macro can prompt the user to select the range of the scroll box.
00:00 Presentation
00:17 Method 1: Set the ScrollArea worksheet property (temporary solution)
01:06 Method 2: Set the ScrollArea when the sheet is enabled (permanent solution)
02:34 Method 3: Three macros to set and clear the ScrollArea
#exceltutorial #exceltips
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments