Junior Member

Posts: 9

how can I lock/unlock a range of cells depending on state of a checkbox?

I have a checkbox in C15 which is linked to AC1.
underneath it in the range C19:L24 I have colums and rows of info the user can input data into.
Now I want that range of cells to lock if the checkbox is unchecked(FALSE) and to unlock if the checkbox is checked(TRUE).

In the same sheet I have the exact same setup where the checkbox is in O15 and linked to AC2.
and the range I wish to lock/unlock with that checkbox is O19:X24

How can I accomplish this?
Thank you in advance.

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 or Unlock Range of Cells on Worksheet_Change Event	Grahame Coyle	Excel Worksheet Functions	3	July 14th 08 12:27 AM
Lock/Unlock cells	BFife	Excel Worksheet Functions	2	October 25th 06 03:20 PM
lock/unlock cells	john tempest[_2_]	Excel Programming	7	March 16th 06 07:54 PM
Lock and unlock cells conditionally depending on input in another	Frustrated	Excel Worksheet Functions	1	November 11th 05 03:36 PM
Lock and Unlock Cells	Peter	Excel Programming	5	January 29th 05 04:32 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us