View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
George Nicholson George Nicholson is offline
external usenet poster
 
Posts: 149
Default How can you limit the data entry range in Excel?

In addtion to using the Locked property of Cells and then protecting the
worksheet, you can use the ScrollArea property in VBA to limit what cells
can be selected as well as how much the user is allowed to see.

Worksheets(1).ScrollArea = "a1"

The above would 1) only allow A1 to be selected and 2) the user would not be
able to scroll to any other area of the worksheet.
If i recall correctly, ScrollArea does *not* persist between sessions
(unlike Locked & protection), so you need to place it in Workbook.Open or
something similar.

You also might want to be sure that the specified range is showing before
invoking ScrollArea.

Application.Goto Reference:=Worksheets(1).Range("A1"), scroll:=True

--
HTH,
George


"Joe" wrote in message
...
Is it possible to 'freeze' the cursor position on a spreadsheet so data
can
be entered in one cell only?