Posted to microsoft.public.excel.programming

phil[_2_]

external usenet poster

Posts: 1

When using an Option Button can I...

Lock a particular cell?

I have optYes and optNo. When optYes is selected I would
like the contents of cell M42 on worksheet WS2 to have a
"locked" state, whereas no data can be entered. And when
optNo is selected I would like the contents to be fully
editable. Is there such a work-around for this?

Thanks in advance for your help.

Phil Diederich

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
keep source formatting is not an option in paste option button	Tina	Excel Discussion (Misc queries)	0	February 20th 06 09:58 PM
Getting value of Option button	BG	Excel Worksheet Functions	2	September 27th 05 01:47 PM
Option Button Help	justaguyfromky	Excel Worksheet Functions	2	September 5th 05 10:28 PM
Option Button Help	justaguyfromky	Excel Discussion (Misc queries)	1	September 5th 05 09:48 PM
option button	Mario	Excel Discussion (Misc queries)	1	July 26th 05 07:44 PM

All times are GMT +1. The time now is 01:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us