LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Locking Cell

I am trying to creat a form where in our clients need to entre detials.I am
trying to provided two options out of which one has to selected by the
client.on selecting one option the other optional cells should get
deactivated or lock so that no value can be entred in the other optional
Cell..

Is there any way to do this....
 
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
Locking cell whatzzup Excel Discussion (Misc queries) 2 November 1st 07 08:16 PM
locking only one cell AJB Excel Discussion (Misc queries) 2 August 17th 07 09:40 AM
locking formula in cells in without locking whole sheet SuziQ Excel Discussion (Misc queries) 1 July 21st 06 03:58 PM
Dynamically locking a cell depending upon value of another cell. Pank Excel Discussion (Misc queries) 0 May 12th 06 11:48 AM
Locking a cell John Excel Worksheet Functions 1 December 17th 05 01:04 PM


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