Posted to microsoft.public.excel.programming

external usenet poster

Posts: 6

lock cells

Greetings,

As a newbee to VBA I could use some help he

I have a small spread sheet that uses A1:G5 the cells in question are
Columns D-G

D1=Powered
E1=Glider
F1=Corporate
G1=Member Owned

D2, E2, F2, G2 should allow for an "X" only in the cell.
An "X" in D1 should Lock E2 and vice-versa
An "X" in F2 should Lock G2 and vice-versa

TIA
Joe

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
Lock CELLS	sohail	Excel Discussion (Misc queries)	2	March 23rd 10 07:44 PM
Lock cells	Mitesh Hirani[_2_]	Excel Discussion (Misc queries)	2	December 3rd 09 12:28 PM
HOW DO I LOCK CERTAIN CELLS	Dan A.	Excel Discussion (Misc queries)	2	October 16th 09 10:13 PM
lock cells.	Miri	Excel Discussion (Misc queries)	1	February 21st 07 09:42 AM
lock cells	Novice	New Users to Excel	4	November 30th 06 01:44 AM

All times are GMT +1. The time now is 04:10 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us