+ Reply to Thread
Results 1 to 3 of 3

Editing an unlocked cell within a table on a protected worksheet

  1. #1
    Registered User
    Join Date
    05-24-2015
    Location
    Mackay, Australia
    MS-Off Ver
    2010
    Posts
    2

    Editing an unlocked cell within a table on a protected worksheet

    I have the following message pop up whenever I go to edit a cell on a protected worksheet. The cells are 'unlocked', and they still let me enter/delete data in them, but the message pops up.

    "The cell or chart that you are trying to change is protected and therefore read-only.
    To modify a protected cell or chart, first remove protection using the Unprotect Sheet command....."

    Just can't understand why it pops up on the unlocked cells and then lets me edit them anyway.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Editing an unlocked cell within a table on a protected worksheet

    Please attach a copy of your workbook so we can work on a solution using your own worksheet. Remember to remove/replace any sensitive info before uploading the file.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

  3. #3
    Registered User
    Join Date
    05-24-2015
    Location
    Mackay, Australia
    MS-Off Ver
    2010
    Posts
    2

    Re: Editing an unlocked cell within a table on a protected worksheet

    Road Signs Worksheet.xlsm

    The cells with the white background are the unlocked cells. If you try to delete either of the numbers shown in these cells, the error pops up (eventhough they are unlocked).

+ 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. Don't select any cell on protected worksheet with unlocked cells
    By L.Overes in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-18-2013, 03:22 AM
  2. Table Editing in a Protected Worksheet
    By avsimmons in forum Excel General
    Replies: 2
    Last Post: 08-09-2012, 12:07 PM
  3. Replies: 1
    Last Post: 03-07-2009, 03:42 AM
  4. Htperlink in an unlocked cell but protected worksheet
    By ywc in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-25-2006, 08:50 PM
  5. Replies: 1
    Last Post: 06-16-2005, 07:05 PM

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