Posted to microsoft.public.excel.programming

john tempest[_2_] john tempest[_2_] is offline

external usenet poster

Posts: 27

lock/unlock cells

say i have 2 cells B20 and B21. when i enter a number in B20 i want B21 to
lock, i also want this to work via versa so if i enter a number in B21 i want
B20 to lock. this is so a number cannot be put in both cells
is this possible
thankyou john tempest

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
Using a Check Box to Lock/Unlock Cells	[email protected]	Excel Discussion (Misc queries)	3	April 27th 23 11:43 AM
Lock/Unlock cells	BFife	Excel Worksheet Functions	2	October 25th 06 03:20 PM
Lock and Unlock Cells	Peter	Excel Programming	5	January 29th 05 04:32 PM
Lock and Unlock cells using VBA	Peter	Excel Discussion (Misc queries)	1	January 29th 05 02:00 PM

All times are GMT +1. The time now is 06:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us