Thread: Protect cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Edwin Tam[_3_] Edwin Tam[_3_] is offline
external usenet poster
 
Posts: 1
Default Protect cell

By default, if you choose to protect the cells in a worksheet, all cells on that worksheet are protected

However, if you want to protect only some of the cells (but not the rest), you can do the following steps

1) Select all the cells on the current worksheet (Ctrl + A
2) From the Format menu, choose "Cells
3) In the form that pops up, choose the "Protection" tab, uncheck the "Locked" checkbox. Click OK
4) Select those cells you would want to protect
5) From the Format menu, choose "Cells
6) In the form that pops up, choose the "Protection" tab, check the "Locked" checkbox. Click OK
7) From the "Tools" menu, choose "Protection", then "Protect Sheet"
8) Click OK

Regards
Edwin Ta
http://www.vonixx.co


----- singkit wrote: ----

Hi

Is there a way I can protect specific
cell in a work sheet

Please help

Thank