How do I: prevent user from scolling down and right?

  • Thread starter Thread starter jasonsweeney
  • Start date Start date
J

jasonsweeney

I have a spreadsheet that has all the data the user needs to see in
small area. There are calculations that I want to prevent the use
from seeing on the worksheet.

Can I prevent the user from being able to scroll right? It has to b
clean. As in, if they scroll to the right, the window just stops, a
opposed to jumping all the way back to the left.

I also need to prevent the user from scolling down.

Any help would be appreciated
 
Jason,

Go into your VBE [Tools] --> Macros --> Visual Basic Editor

Select the sheet you want to regulate the scrolling (sheet 1)
Press F4 to bring up the sheet property window... Locate Scroll Are
and enter the area you want to be able to scroll to, i.e.
$A$1:$M$49..

Hope this helps

Rockee Freema
 
Jason

You may want to try setting the Scroll Area.

This setting will not remain after closing the file.
Place a code line in the Workbook open event to set it
each time when you open the workbook

Private Sub Workbook_Open()
Sheets("Sheet1").ScrollArea = "A1:M35"
End Sub

Adjust to your sheetname and range.

Gord Dibben Excel MVP
 
Back
Top