#1   Report Post  
Juco
 
Posts: n/a
Default 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


  #2   Report Post  
Ragdyer
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 12:57 PM
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:17 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM
How do I email selected excel cells to multiple recipients? AShaffer Excel Worksheet Functions 1 October 30th 04 01:37 PM


All times are GMT +1. The time now is 11:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"