VBA & Macro Problems

How to Auto-Scroll and Loop an Excel Workbook on a TV Display

WPS Content Manager Oct 10, 2026 868 views

Question details

The user needs a way to continuously scroll and loop specific cell ranges in an Excel workbook to display it as a presentation on a TV monitor.

How to Auto-Scroll and Loop an Excel Workbook on a TV

Product: Microsoft Excel
Device & OS: not provided
Scenario: Displaying a SharePoint-hosted Excel workbook as a continuous, unattended presentation on a screen.
Observed behavior: Excel lacks a native presentation mode for auto-scrolling and looping, requiring a custom VBA macro solution to automate the view.

Before you start

Ensure your Excel file is saved in a macro-enabled format (.xlsm) and identify the exact cell ranges (e.g., A1:K30) you want the screen to cycle through.

Solution 1Recommended

Create a VBA Macro to Auto-Scroll and Loop Ranges

Write and execute a custom VBA script that selects specific ranges, pauses, and loops continuously for presentation purposes.

Since Excel does not have a built-in slideshow mode, you can use Visual Basic for Applications (VBA) to force the application to scroll to different sections of your worksheet at specific time intervals.

Open the VBA Editor

Press Alt + F11 on your keyboard to open the VBA Editor. Click 'Insert' in the top menu and select 'Module' to create a new script area.

Write the looping macro

Create a subroutine that uses 'Application.Goto' to select your first range, followed by 'Application.Wait' to pause for a few seconds. Repeat this for each range you want to display, and call the subroutine again at the end to create an infinite loop.

Test the presentation flow

Run the macro by pressing F5. Verify that the screen scrolls to the desired areas and pauses correctly before moving to the next section.

Configure SharePoint settings

If the workbook is opened from SharePoint, ensure your Trust Center settings allow macros to run. Test the macro on the actual display computer to ensure network syncs do not interrupt the script.

Create a VBA Macro to Auto-Scroll and Loop Ranges

Interrupting the Loop: Because this macro creates a continuous loop, you will need to press the 'Esc' key or 'Ctrl + Break' to pause or stop the code execution when you want to edit the workbook.

Powerful Spreadsheet Tool

Use WPS Spreadsheet for VBA Presentations

WPS Office fully supports VBA macros, allowing you to create customized auto-scrolling dashboards and loop specific ranges seamlessly for unattended TV presentations.

1. Download and Install WPS Office: Get the free version of WPS Office from the official website and install it on your presentation computer.
2. Open your Macro-Enabled File: Launch WPS Spreadsheet and open your .xlsm file containing your dashboard data.
3. Access the VBA Editor: Navigate to the 'Developer' tab on the ribbon and click 'VBA Editor' to input or review your looping script.
4. Run the Presentation: Execute your auto-scroll macro. Expand the WPS Spreadsheet window to full screen to display your data cleanly on the TV.

Full support for VBA (Visual Basic for Applications)Highly compatible with Microsoft Excel formats (.xlsx, .xlsm)Lightweight performance ideal for continuous monitor displays

microsoft office alternative - wps office

Frequently Asked Questions

Can I auto-scroll an Excel sheet without using VBA macros?

No, Excel does not have a native auto-scroll or presentation slideshow feature. You must use VBA macros, a third-party add-in, or recreate the dashboard in a dedicated presentation tool like PowerPoint.

Why does my macro stop when the workbook updates from SharePoint?

SharePoint auto-saving or online data refreshes can interrupt VBA execution. To prevent this, check out the file or open it in the desktop application with exclusive read-only access for the display screen.

How do I make the macro start automatically when the file opens?

You can trigger the macro automatically by placing your loop code inside the 'Workbook_Open()' event in the 'ThisWorkbook' module of the VBA Editor.

Excel & Data Problems