Posted to microsoft.public.excel.programming

nospam

external usenet poster

Posts: 16

selective protection

In message , Tom
Ogilvy writes
that is correct, the default value of the Locked property of each cell is set
to True.

Try selecting the cells you want unlocked (with the worksheet unprotected)
and unchecking the locked property in Format=Cells=Protection tab. Then
protect the sheet.

Thanks, just what I was after.

--
Nospam

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
selective protection	Dave[_6_]	New Users to Excel	0	February 27th 08 02:15 PM
Selective cell protection	Trilux_nogo	Excel Worksheet Functions	1	May 12th 07 08:29 PM
Selective protection of charts - permit only beforedoubleclick?	Jon Peltier[_5_]	Excel Programming	0	January 23rd 04 11:41 PM
Selective Protection of a Worksheet	DCMyers1	Excel Programming	2	December 30th 03 08:06 PM
Selective protection of charts: permit only BeforeDoubleClick ?	David Powell	Excel Programming	0	July 14th 03 01:14 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us