ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   selected cells (https://www.excelbanter.com/excel-worksheet-functions/12921-selected-cells.html)

Juco

selected cells
 
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



Ragdyer

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





All times are GMT +1. The time now is 04:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com