#1
|
|||
|
|||
Protect cells
How do I protect cells in Excel 2007. I do know that I can encript a document with a password. But that is a password to open the document. I don't want that. I want the user to be able to opwn the document but not protected ones. By default they are protected anyway. TIA |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
You can't protect a particular cell only - you have to protect worksheet. But you can determine, how the protection will affect particular cells in this worksheet (is editing allowed, is data validation allowed, are formulas/manually entered values displayed in formula bar, etc.
Select whole worksheet (click at left of 1st column - column A - label). Select Format Cells and activate Protection tab. Set options Locked and Hidden for all cells on worksheet; Select any range in worksheet you want to follow different protection rules. Select Format Cells and activate Protection tab again. Set rules for this range; Repeat the process until you protection rules for all needed ranges are set; From Review menu, select Protect Sheet. At bottom of Protect window, you can allow additional options for locked/unlocked cells in worksheet. Enter password and click OK. you are asked to repeat the password. Optionally you may leave password unfilled. After you have protected the worksheet, user can edit cells which are unlocked, and he/she can't edit any other cells in worksheet. There are some protection options, which you can set only using VBA code (I'm not sure about Excel2007, but in older versions the option to set additional allowances when protecting the sheet was not available - you had to do this through VBA only). |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to protect cells and still be able to use all data entry form | Jae | Excel | 2 | 11-13-2019 05:32 PM |
How do I un-protect docs I didn't protect? | doctorduncan | Word | 4 | 05-30-2019 11:09 AM |
How can I automatically protect only certain cells in Excel 2010 | KelStin | Excel | 8 | 03-26-2017 08:00 PM |
Excel VBA: Worksheet_Change Cells.Protect | tinfanide | Excel Programming | 8 | 04-08-2012 09:58 PM |
Protect / Lock Cells / Print Set-up? | meggenm | Excel | 3 | 01-26-2012 09:57 PM |