I would like to hide / unhide columns using a scroll bar (from either the forms toolbar or control toolbox). For example, I have a range of data (held within columns) that stretches from left to right on screen. Rather than use the horizontal scroll bar to scroll left to right across the entire worksheet, I simply want to scroll, left to right (and then back again) across a predetermined range. I though I may be able to do this by hiding / unhiding columns whenever I clicked on either the left or right side of the scroll bar.
Can anyone help ?
Can anyone help ?