ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Protection of cell in excel (https://www.excelbanter.com/excel-programming/434321-protection-cell-excel.html)

Sanjay Sharma

Protection of cell in excel
 
Hi,

I would like to protect some particular coloum, I was using formate
cell-protection-Lock, but it was not working, Kindly let me know how do I
do it?

Jacob Skaria

Protection of cell in excel
 
All cells are locked by default, but locking does not mean anything until
you protect the worksheet from ToolsProtection menu.

--First select any cells that a user is allowed to change
--Hit Ctrl+1 and go to the 'Security' tab to unlock these cells.
--Go to Tools-Protection-Protect Sheet, and you can assign a password
(optional)

If this post helps click Yes
---------------
Jacob Skaria


"Sanjay Sharma" wrote:

Hi,

I would like to protect some particular coloum, I was using formate
cell-protection-Lock, but it was not working, Kindly let me know how do I
do it?



All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com