While I'm at it, am I right in thinking I can protect a sheet, and a whole workbook, but.. - Wrath of the Barclay

While I'm at it, am I right in thinking I can protect a sheet, and a whole workbook, but..

not a column, row or range of cells?

Posted By: APB on September 12th 2012 at 22:21:22

Message Thread

Rusty Steele, Yellalee, yarmyyarmy, Karnivore, Charles21, Pixelman (General Chat) - APB, Sep 12, 22:10:25
- While I'm at it, am I right in thinking I can protect a sheet, and a whole workbook, but.. (General Chat) - APB, Sep 12, 22:21:22
  - No, you can change the format of cells to be unprotected, and then protect the sheet (General Chat) - Yellalee, Sep 12, 22:22:44
    - Yep. Go into format cells menu --> Protection. Deselect 'locked', then protect your sheet (n/m) (General Chat) - Yellalee, Sep 12, 22:24:53
      - ***** (General Chat) - dr fanta, Sep 12, 22:26:03
      - That is, highlight and format the cells to be left unlocked, i.e. most of them (n/m) (General Chat) - Yellalee, Sep 12, 22:25:46
        
        Shall try that now. Two weeks! (n/m) (General Chat) - APB, Sep 12, 22:38:36
        
        Oh yes. Very ready now. (n/m) (General Chat) - Yellalee, Sep 12, 22:40:37
    - I'm wading through the help shizzle, and know how to protect sheets and that. (General Chat) - APB, Sep 12, 22:24:01
      - excel help is sh!t (General Chat) - dr fanta, Sep 12, 22:25:02
  - no (n/m) (General Chat) - dr fanta, Sep 12, 22:22:16
    - No, I'm not right, or no, I can't? (n/m) (General Chat) - APB, Sep 12, 22:22:47
      - you're not right (General Chat) - dr fanta, Sep 12, 22:24:06

Reply to Message

In order to add a post to the WotB Message Board you must be a registered WotB user.

If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.