$$Excel-Macros$$ How to lock / Protect Cell, Column Row in excel.

2013-07-19 Thread Prabhakar S H
Dear Team, I know how to protect sheet. but not able to protect / lock particular cell / row and column in Excel. Can you pls help in attached excel sheet how to do it. Also pls tell me how to protect Formulas in Excel. Rgds, Prabhakar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

Re: $$Excel-Macros$$ How to lock / Protect Cell, Column Row in excel.

2013-07-19 Thread P.VIJAYKUMAR
Respected Prabhakar, First select all the sheet and go to format tab and go to the protection tab and uncheck the locked and hidden chechmarks.Then Select the Cells,Rows or Columns which you want to lock,the go to the format tab and then the protection tab in the dialog box then check the locked