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

--
Message posted from http://www.ExcelForum.com

you could hide your Column/rows and protect the workboo

--
Message posted from http://www.ExcelForum.com

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

--
Message posted from http://www.ExcelForum.com

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

On Thu, 5 Feb 2004 12:07:10 -0600, jasonsweeney
wrote:

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

Can I prevent the user from being able to scroll right? It has to be
clean. As in, if they scroll to the right, the window just stops, as
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.


---
Message posted from http://www.ExcelForum.com/