Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Locking everything except cells B4:B8
Hi, can someone help me lock this sheet except for these cells - I've tried
doing the Protect Sheet but everything seems to get locked? Thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Locking everything except cells B4:B8
Select the range you want to unlock and go to Format|Cells and in the Protection tab uncheck the "Locked" checkbox.. click Ok. Now re-protect the sheet through Tools|Protection|Protect Sheet. -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113004 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Locking everything except cells B4:B8
Hi,
before protecting the sheet you need to unlock the cells, so select the cells where you want to let users to enter information, right click on the mouse, format cells, then last tab "Protection", uncheck locked, then protect the worksheet "H" wrote: Hi, can someone help me lock this sheet except for these cells - I've tried doing the Protect Sheet but everything seems to get locked? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking Cells | Excel Worksheet Functions | |||
Locking certain cells | Excel Discussion (Misc queries) | |||
Locking cells | Excel Worksheet Functions | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
Locking certain cells | Excel Discussion (Misc queries) |