Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a spreadsheet whereby a number of the cells are protected and only
those that require info to be inserted can the user insert data. Is it possible to list the order (cell no) that the cursor jumps after they press enter? thanks Juco |
#2
![]() |
|||
|
|||
![]()
Where you wish to enter data into unprotected cells in a protected WB, you
should hit <Tab in order for the focus to move to the next unprotected cell. If, on the other hand, you wish to follow an *exact* preferred order of data input, you could try the procedure in this old post: http://tinyurl.com/39vzv -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Juco" wrote in message k... I have a spreadsheet whereby a number of the cells are protected and only those that require info to be inserted can the user insert data. Is it possible to list the order (cell no) that the cursor jumps after they press enter? thanks Juco |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
How do I email selected excel cells to multiple recipients? | Excel Worksheet Functions |