I'm trying to figure out a way to make the scroll area on a sheet variable. Currently, I have a drop down which uses smallscroll to navigate between a set of charts on a sheet. Once that routine has run though, I would like to lock the scroll area so that the user cannot scroll up and down past the selected charts. However, if the dropdown is changed, the scroll area also needs to change.
I've tried inserting the correct scroll areas at the end of each case statement, but this only seems to work for the first case encountered, i.e. Excel sets the scroll area and will not change it if a new case is selected.
Essentially, what I may looking for a is a way to reset the scroll area (or clear it from the active sheet's properties) to the entire sheet and then lock it again. I tried doing .scrollarea="" followed by .scrollarea="whatever it needs to be" but the scrollarea doesn't get reset.
Also, hiding rows is not an option...
Thanks!
I've tried inserting the correct scroll areas at the end of each case statement, but this only seems to work for the first case encountered, i.e. Excel sets the scroll area and will not change it if a new case is selected.
Essentially, what I may looking for a is a way to reset the scroll area (or clear it from the active sheet's properties) to the entire sheet and then lock it again. I tried doing .scrollarea="" followed by .scrollarea="whatever it needs to be" but the scrollarea doesn't get reset.
Also, hiding rows is not an option...
Thanks!