LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
DME
 
Posts: n/a
Default Protected Cell

I have an input sheet that user input data and it calculates a sales price.
I have locked the worksheet and uprotected the cells where the user needs to
input information. My question, is there a way that makes it only possible
for the user to have access to the unlocked cells. In other words, when the
user inputs info into a certain cell, the cursors jumps to the next unlocked
cell. Basically I just want to give them access to the unlocked cells.


 
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
Cell addressing using the content of another cell. Jandon Excel Worksheet Functions 1 March 30th 05 06:39 PM
CELL PROTECTED IN 2000, UNPROTECTED IN 2003 Carole O Excel Worksheet Functions 0 January 20th 05 07:17 PM
How do I make a cell equal to another cells value and not it's fo. TroutKing Excel Worksheet Functions 2 January 17th 05 06:15 PM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 02:06 AM
Formatting a cell as "text" in the number catagory. Ed Excel Worksheet Functions 3 December 7th 04 07:12 PM


All times are GMT +1. The time now is 11:48 AM.

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"