Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Protect all but the cells desired or in a more complicated series, use a
worksheet_change event if target.address="$A$1" then range("c3").select if target.address="$C$3" then range("d6").select or if target.address="$A$1" then target.offset(2,2).select -- Don Guillett SalesAid Software "Xavi Temporal" wrote in message ... Hello! I'm creating a worksheet with a lot of protected cells, and only several cells are available for the user. Well, I want to know if it's possible to "guide" the user just to seleced cells, so, when someone opens the worksheet, the cursor would move to "first" cell (I've selected), then the user only can move by the sequence of cells I've defined. Is it possible? I want a worksheet that looks like a form. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel check boxes moving when excel selected cells pasted in word | Excel Discussion (Misc queries) | |||
Moving to next row below a selected range | Excel Programming | |||
Moving selected data | Excel Worksheet Functions | |||
Moving between a cell that is selected to include a range of cells in that row | Excel Programming | |||
Moving selected sheets | Excel Programming |