Posted to microsoft.public.excel.misc

Neil Pearce Neil Pearce is offline

external usenet poster

Posts: 109

Lock Cells

Dear all,

I wonder if someone could help?

I have a range of cells, B2:AY51, I wish to select all the range and 'lock'
them for protection. Then I'd like to 'unlock' only those that are red.

Thanking-you in advance,

Kind regards,

Neil

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	Snook	Excel Discussion (Misc queries)	1	January 16th 08 06:41 PM
why do some cells not lock?	CDecuir	Excel Discussion (Misc queries)	1	April 16th 07 08:31 PM
How To Lock Cells	Ziggy M	Excel Discussion (Misc queries)	3	August 18th 06 02:24 PM
how can I lock certain cells?	Linds	Excel Discussion (Misc queries)	2	December 20th 05 10:46 PM
Lock Cells	Diana	Excel Discussion (Misc queries)	2	September 26th 05 07:27 PM

All times are GMT +1. The time now is 04:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us