I have added a vertical scroll bar to a worksheet, I want the maximum value when the slider is at the top. I can find no way to achieve this. The Rotation checkbox is greyed out. Any ideas?
T.I.A.
Scroll Bar Orientation
-
- 5StarLounger
- Posts: 689
- Joined: 27 Jan 2010, 16:45
- Location: Ottawa, Ontario, Canada
Scroll Bar Orientation
Regards
Don
Don
-
- Administrator
- Posts: 78648
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Scroll Bar Orientation
You can't do that, but of course you can interpret the value the way you want. Let's say the minimum value is 0 (at the top) and the maximum is 100 (at the bottom). You can use (100 - the scroll bar value) instead of the scroll bar value itself.
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 689
- Joined: 27 Jan 2010, 16:45
- Location: Ottawa, Ontario, Canada
Re: Scroll Bar Orientation
Thank you Hans. Let's put that down to a 'Senior's Moment">HansV wrote: of course you can interpret the value the way you want.
Regards
Don
Don