software

I would like to be able to change only a few cells within a workbook say
cells b3/d5 etc…. and the rest of the workbook can not be changed, –
how do I protect it in this way? thank you--
chrissywhittle
------------------------------------------------------------------------
chrissywhittle's Profile: www.excelforum.com/member.php...oamp;userid=32158
View this thread: www.excelforum.com/showthread...hreadid=523040Hi Chrissy
By default, all of Excel's cells are Locked, but that doesn't become
operative until you apply Protection to the sheet.
So, mark the range of cells you wish to allow alteration and
Formatgt;Cellsgt;Protectiongt; remove the check mark for Locked.
Then Toolsgt;Protectiongt;Protect Sheetgt; optional whether you use a password
or not, but be sure to remember it if you do give one.

Please note, even with a password, it is not totally secure, as there
are plenty of password removal algorithm's freely available on the web
which will allow the user still gain access to the cells if they are
determined.

--
Regards

Roger Govierquot;chrissywhittlequot;
lt;chrissywhittle.24rhr0_1142511303.3724@excelforu m-nospam.comgt; wrote in
message
news:chrissywhittle.24rhr0_1142511303.3724@excelfo rum-nospam.com...
gt;
gt; I would like to be able to change only a few cells within a workbook
gt; say
gt; cells b3/d5 etc.. and the rest of the workbook can not be changed, -
gt; how do I protect it in this way? thank you
gt;
gt;
gt; --
gt; chrissywhittle
gt; ------------------------------------------------------------------------
gt; chrissywhittle's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32158
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=523040
gt;
Hi,

Tools -gt; Protection -gt; Allow Users To Edit Ranges -gt; New

Select the cells you want the users to be able to edit and click
Protect Sheet.

Regards
MartinHi

By default, Excel's cells are all locked - but remain in use until the
worksheet is protected.
Select the cells you want to use and go to Format/Cells and click on the
last tab, Protection. Uncheck the Locked option. Now you can protect the
sheet by going to Tools/Protection . . Protect Sheet.

Hope this helps.
Andy.

quot;chrissywhittlequot;
lt;chrissywhittle.24rhr0_1142511303.3724@excelforu m-nospam.comgt; wrote in
message news:chrissywhittle.24rhr0_1142511303.3724@excelfo rum-nospam.com...
gt;
gt; I would like to be able to change only a few cells within a workbook say
gt; cells b3/d5 etc…. and the rest of the workbook can not be changed, –
gt; how do I protect it in this way? thank you
gt;
gt;
gt; --
gt; chrissywhittle
gt; ------------------------------------------------------------------------
gt; chrissywhittle's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32158
gt; View this thread: www.excelforum.com/showthread...hreadid=523040
gt;