Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
move cursor on limited cells.
Hi,
I have a sheet which have dozen of cells and rows but i want that someone who ever is using that workbook that could move only on limited cells e.g. only on C3, C15, C48 and E55 the user can edit as well and if a user try to click on any other cell cursor or mouse will not be able to select that Cell. I have already protected that worksheet by password. Please let me know. Thanks F1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
move cursor on limited cells.
1. unprotect the worksheet
2. protect all cells 3. unprotect only the "free cells" 4. re-protect the worksheet -- Gary''s Student - gsnu2007h "Invisible" wrote: Hi, I have a sheet which have dozen of cells and rows but i want that someone who ever is using that workbook that could move only on limited cells e.g. only on C3, C15, C48 and E55 the user can edit as well and if a user try to click on any other cell cursor or mouse will not be able to select that Cell. I have already protected that worksheet by password. Please let me know. Thanks F1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make the cursor move down 8 cells each time I press ente | Setting up and Configuration of Excel | |||
How can I make the cursor move down 8 cells each time I press ente | Setting up and Configuration of Excel | |||
Locked spreadsheet, move cursor only to unlocked cells? | Excel Worksheet Functions | |||
Move cursor through all unprotected cells in a protected worksheet | Excel Discussion (Misc queries) | |||
Formula to move cursor when 2 cells equal | Excel Discussion (Misc queries) |