+ Reply to Thread
Results 1 to 2 of 2

Cell Lock ignored, yes Sheet is Protected...how possible?

  1. #1
    Registered User
    Join Date
    11-26-2014
    Location
    My house
    MS-Off Ver
    2003
    Posts
    1

    Cell Lock ignored, yes Sheet is Protected...how possible?

    Hello,

    Cells C4 and D4 are empty cells, and both are locked in Format Cells->Protection-> Locked.

    I go to Tools-> Protection-> Protect Worksheet, use the default checkboxes.

    Now it does not let me change the contents of C4, but it DOES let me change the contents of D4!

    How is that possible?

    This is Excel 2003.

    I had the same problem with the entire 1st row ignoring the Locked flag, so I deleted the row and Inserted a new row, that fixed it.

    But I can't delete this single cell (Pasting a working cell over the top if it does not fix the problem).

    Why is this happening? How do I fix it?

    That cell might have been one where I had been experimenting with pull-down lists at one point, but as I said, it is blank now. And pasting a never-used, empty cell over it does not fix the problem.

    Thanks,
    Mark

  2. #2
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    Office 365
    Posts
    973

    Re: Cell Lock ignored, yes Sheet is Protected...how possible?

    Send this "Bugged" book so that we can test and make sure there is not something else going on -
    -If you think you are done, Start over - ELeGault

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using checkbox to lock & gray out cells - in a protected sheet
    By iugaramo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2014, 09:59 AM
  2. [SOLVED] Trying to lock cells on protected sheet, no success.
    By tv69 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2013, 01:45 PM
  3. Replies: 5
    Last Post: 07-15-2013, 03:57 AM
  4. Macro to Lock cells in protected sheet depending on criteria
    By Zyphon in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-30-2008, 12:00 PM
  5. [SOLVED] lock tab in sheet 2 until cell in sheet one is completed
    By john tempest in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-24-2005, 04:50 AM

Tags for this Thread

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