LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gareth - Network analyst.
 
Posts: n/a
Default Cell locking dependent on Cell value

Hi Guys I always seem to have questions that are complex...

What im looking to do On a standard sheet Various cells. can i have a cell
that will not allow you to edit it unless another cell value is a spcified
Value.. basically a password thing.... what i am doing is this.

I have a Sheet whete cell C2 is where i want the user to enter a password
from several or even just one that i have defined. should that cell have the
correct value then cell D2 will allow you to edit its value. else the cell
should be locked for editing... is this possable? and how would i do it....
and please tell me you can do it without VB scripting.

 
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
Furmula Dependent Cell References ned Excel Discussion (Misc queries) 2 May 4th 06 05:03 PM
resetting last cell jagdish.eashwar Excel Discussion (Misc queries) 11 March 31st 06 02:06 AM
Instead of a negative number, I'd like to show zero... Dr. Darrell Excel Worksheet Functions 6 December 7th 05 08:21 PM
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 01:08 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"