Set scroll area ???

I read somewhere that I can set the area that is scrollable so that the user
can't scroll past a certain cell on the spreadsheet. I can't figure out how
to do this, nor can I find the source of the information I originally read.

Any help would be appreciated.

Jonco

Worksheets(1).ScrollArea = "a1:f10"

try this

Regards Ron

"Jonco" <jhea...@hdynamics.com> schreef in bericht
news:%wKs7.16367$ck.1...@sjc-read.news.verio.net...

Hi Jonco,
You can set the scroll area but it will not persist through
closing and reopening of the file. So it may be of little use to you.

F1 (Help) --> index --> scrollarea [example copied below]

ScrollArea Property Example:
This example sets the scroll area for worksheet one.
Worksheets(1).ScrollArea = "a1:f10"

You probably are thinking of protected cells. All cells by
default are protected but is meaningless until the sheet itself
is protected. You should be able to pick up the rest from
any book or from help.
select cells to be unprotected
format > cells > protection, remove checks
Tools > protection protect workbook
If all you are trying to do is prevent keying errors and help
with moving cursor, you would not need to implement a password.

HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Macros: http://www.geocities.com/davemcritchie/excel/excel.htm
Search Page: http://www.geocities.com/davemcritchie/excel/search.htm

"Jonco" <jhea...@hdynamics.com> wrote in message news:%wKs7.16367$ck.1...@sjc-read.news.verio.net...

Hello Jonco !

To define the scroll area you have to switch to the VB part of Excel. To do
this, just hit <ALT> + <F11>.
In this VB editor you should see a column on the left side listing all
available Worksheets, if not, try to activate the "Project Explorer".

Select the Worksheet which scroll area you want to define.
Additionally there should be a "Settings" or "Properies" sections visible in
the left column, if not try to activate it to.

In the "Settings" part there are several attributes of a Worksheet listet,
one of them is the "ScrollArea".
For defining a scroll area use a syntax in the form like "$A$1:$D$28",
that's all.

Another useful hint when using a "ScrollArea" is the "EnableSelection"
attribute of a Worksheet. When this attribute is set to "1 -
xlUnlockedCells" the user is able to navigate through "unlocked" cells only
(see the "Format Cell" Dialog).

Regards, Bruno

PS: Hope the Dialog names are correct because I'm using a German Version of
Excel

Defining the scroll area
"Jonco" <jhea...@hdynamics.com> schrieb im Newsbeitrag
news:%wKs7.16367$ck.1...@sjc-read.news.verio.net...

thanks... that's what I needed to know.

Jon