Yossi

Posts: n/a

Locking cells dynamically

Hi,
Is there an option in Excel to lock cells on a certain condition?
For example if a value in A1 is "X" than cell B1 will be locked otherwise it
will be unlocked.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 Cells	WendiW	Excel Discussion (Misc queries)	1	March 10th 05 08:15 PM
Help on locking cells	B	Excel Discussion (Misc queries)	1	January 28th 05 04:17 AM
Change a cell's fill color dynamically?	Arlen	Excel Discussion (Misc queries)	2	January 22nd 05 09:51 PM
How can I dynamically eliminate blank cells in a given range in E.	Scott Steele	Excel Worksheet Functions	6	December 17th 04 03:23 AM
Locking certain cells	Marvin	Excel Worksheet Functions	1	December 7th 04 07:13 PM

All times are GMT +1. The time now is 05:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us