Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell protection in Excel | Excel Discussion (Misc queries) | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
EXCEL CELL PROTECTION | Excel Worksheet Functions |