+ Reply to Thread
Results 1 to 2 of 2

Can't lock specific cells.

  1. #1
    Registered User
    Join Date
    05-18-2007
    Posts
    5

    Unhappy Can't lock specific cells.



    I unlocked the document and selected several cells but when I lock the document ... it's all or nothing.

    I'd like to lock cells like the header and footer information.

    help?

  2. #2
    Registered User
    Join Date
    05-18-2007
    Posts
    5
    Forgot to mention - I tried several methods, including:

    These steps:
    1) Select the whole sheet (Ctrl+A), right click, Format Cells..., under Protection tab uncheck Lock option.

    2) Select the range which you want to be locked (uneditable), right click, Format Cells..., under Protection tab check Lock option.


    and these steps:

    1) Select the whole sheet (Ctrl+A), right click, Format Cells..., under Protection tab uncheck Lock option.

    2) Select the range which you want to be locked (uneditable), right click, Format Cells..., under Protection tab check Lock option.

    3) Press F5, then Special button and check Formulas and hit Ok
    --- I got an error message that no cells were selected.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1