is there such a thing where VBA or script could allow you to maneuver worksheet similar to how you would navigate on google maps

[kbishop94]

Dont know if this is possible, but I thought i would ask... So instead of having to "grab" the scroll bars using the cursor, you could just "grab" anywhere on the sheet and move the sheet up and down. Possible? Here is why I am inquiring: My worksheet/workbook (which is a org char) is locked and the user has no functionability other than just viewing the 1 sheet , or selecting a couple commandboxes that allows him/her to zoom in and out as well as a print button that futher restricts what is actually printed. Thank you, experts.

 

[mole999]

this moves me down the screen minus 40 rows

Application.GoTo Reference:=Range("a" & LR - 40), Scroll:=True

so you could set specific cells like A1 & A300 as necessary

 

[kbishop94]

this moves me down the screen minus 40 rows

Application.GoTo Reference:=Range("a" & LR - 40), Scroll:=True

so you could set specific cells like A1 & A300 as necessary

Thank you! i'LL give it a try later this evening