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

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
 
R

Rockee052

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
 
G

Gord Dibben

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
 
Top