Cell access

  • Thread starter Thread starter Bob Chandler
  • Start date Start date
B

Bob Chandler

Hi...

I want to restrict my user from keying horizontally
beyound column z and vertically beyond row 600. Anyone
know how to do this... I've already removed the scroll
bars.

BC
 
Bob,

Select the whole worksheet and unlock all cells (Cells>Protection uncheck
Locked box)
select columns AA:IV and lock these cells
set worksheet protection (Tools>Protection>Worksheet)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Private Sub Workbook_Open()
With Worksheets("sheet1")
.ScrollArea = "$A$1:$Z$600"
End With
End Sub

If the user disables macros, then the property won't be applied. You might
want to use sheet protection to lock all the cells and unlock A1:Z600
although the user would still be able to scroll outside that range.
 
A slight variation to Bob's idea using Excel XP is to select
<Tools> <Protection> <Protect Sheet...>
and allow the user to select unlocked cells, but not allow users to select
locked cells.
 
Back
Top