| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I protect the cell from users entering values in Excel?
Product: MS Excel - 2002, I want to restrict the viewers or users of the "a
particular cell" of excel worksheet to be read only and write permission should be blocked. experts do comment.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I protect the cell from users entering values in Excel?
Hi Prasad, For protecting the sheet: Select the perticular cell / cells you want to protect. Then go to "Tools -- Protection -- Protect Sheet... Thsi will ask you for the password. The give the password which you can remember. It will protect the sheet from editing. Thanks, Sylvia -- Sylvia ------------------------------------------------------------------------ Sylvia's Profile: http://www.excelforum.com/member.php...o&userid=30300 View this thread: http://www.excelforum.com/showthread...hreadid=500581 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trend Line constants as Excel Cell Values | Excel Discussion (Misc queries) | |||
| Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
| I need to protect all but one cell in an Excel XP spreadsheet. | Excel Discussion (Misc queries) | |||
| Protecting Workbook | Excel Discussion (Misc queries) | |||
| Remove the apostrophe (') in Excel cell text values | Excel Discussion (Misc queries) | |||
Linear Mode
