• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Add Horizontal and Vertical Scroll Bar

C

cyliyu

Member
I want to disable Excel Horizontal and Vertical scroll bar that came with the program and create my own to control the no of pages the user and scroll.
Would need help please.
 

Attachments

  • Chandoo_Scoll_Bar.xlsx
    16.1 KB · Views: 2
Hi ,

I think what you want may not be possible , or even possible , is a round-about way of doing what you want done.

The simplest way is to hide all columns and rows beyond your used range ; you can hide all columns after AH , and all rows after 31.

Now , using the in-built scroll bars , the user can scroll only within the visible rows and columns.

Narayan
 
You must log in or register to reply here.
Back
Top