Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell access
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell access
Bob,
Select the whole worksheet and unlock all cells (CellsProtection uncheck Locked box) select columns AA:IV and lock these cells set worksheet protection (ToolsProtectionWorksheet) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Bob Chandler" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell access
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. -- Regards, Tom Ogilvy "Bob Chandler" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell access
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. -- Dana DeLouis Using Windows XP & Office XP = = = = = = = = = = = = = = = = = "Bob Chandler" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Single cell access | Excel Discussion (Misc queries) | |||
how to access a cell value in a different workbook. HELP! | Excel Worksheet Functions | |||
can i access the cell colour programatically? eg if cell is blue | Excel Discussion (Misc queries) | |||
how do i set up a link between one excel cell from an access cell | Excel Discussion (Misc queries) | |||
how to access cell calculator | Excel Discussion (Misc queries) |