+ Reply to Thread
Results 1 to 5 of 5

"This cell you are trying to change is in a protected sheet..." message for unlocked cells

  1. #1
    Registered User
    Join Date
    08-19-2015
    Location
    Toronto, Canada
    MS-Off Ver
    Microsoft 365
    Posts
    19

    "This cell you are trying to change is in a protected sheet..." message for unlocked cells

    Hi Guys,

    I have a worksheet that is protected but I have left a couple of cells unlocked where I want users to enter data that gets fed into complex formulae. When I was protecting the worksheet I made sure to click the "allow users to select unlocked cells" option.

    I have always been able to do this without any issues BUT since yesterday for all newly protected sheets I get the following pop up message when I click into a unlocked cell (even though I enabled the allow users to select unlocked cells).

    Pop up box: "The cell or chart you're trying to change is in a protected sheet. To make change, unprotect sheet. You might be required to enter a password."

    I am still able to enter a value into the data entry unlocked cells but only after I have okayed the above pop-up message. It is quite annoying to have the pop-up appear each time a data entry is made in an unlocked cell. Furthemore, I also get the pop-up message as soon as the protected sheet is opened.

    I use Excel 2016 (that latest version). This never used to happen before.

    How can I disable this pop-up box from appearing. Please help!! It will surely drive all my data entry staff bonkers too.

    Thanks,

    Yusuf

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: "This cell you are trying to change is in a protected sheet..." message for unlocked c

    you select "allow users to select unlocked cells" not edit
    right click on these cells , format, uncheck protection

    locked.jpg
    Last edited by sandy666; 11-17-2017 at 03:50 AM.
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Registered User
    Join Date
    08-19-2015
    Location
    Toronto, Canada
    MS-Off Ver
    Microsoft 365
    Posts
    19

    Re: "This cell you are trying to change is in a protected sheet..." message for unlocked c

    Hi -

    Sorry I don't get the uncheck protection. When I right click the cells (which I want users to be able to enter data into) I only get 2 options under protection tab - Locked and Hidden. I have both these unchecked. Please see attached image.

    I always uncheck these boxes in Protection Tab then go ahead and protect the sheet (and allow users to select unlocked cells). In the past Excel would allow data to be written into unlocked cells in a protected sheet without giving the pop-up message but now it gives a pop-up message for each cell.

    Help!

    Y
    Attached Images Attached Images

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Cool Re: "This cell you are trying to change is in a protected sheet..." message for unlocked c

    I don't know what are you doing there
    see atrtached, protected file (password: (no password) )
    only B is unlocked
    the rest is locked and free for selection

    first what you should do is unprotect sheet/workbook, then unlock selected cells then protect sheet/workbook
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-19-2015
    Location
    Toronto, Canada
    MS-Off Ver
    Microsoft 365
    Posts
    19

    Re: "This cell you are trying to change is in a protected sheet..." message for unlocked c

    Hi -
    So I kept following all your above steps BUT could not get rid of the annoying message. Then I realized I had 2 combo boxes on my worksheet and they had linked cells which I had not unlocked! Once I unlocked the cells linked to the combo boxes and reset protection the pop-up messages disappeared!
    Thanks again for help...
    Best,
    Yusuf

+ 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. [SOLVED] VBscript to stop selection at "-----Original Message-----" plus change ";" in the output
    By 20GT in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-01-2017, 11:46 PM
  2. "Worksheet change" not changing cell on other sheet to match target cell "fill".
    By Ochimus in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-02-2015, 12:02 PM
  3. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  4. Change "Parent" cell based on results of multiple "Children" cells
    By ccowman in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-14-2012, 02:33 AM
  5. "Can't change this cell" error message
    By adamfitz77 in forum Excel General
    Replies: 7
    Last Post: 10-11-2011, 07:39 AM
  6. Replies: 2
    Last Post: 06-28-2010, 05:26 PM
  7. Replies: 0
    Last Post: 06-01-2006, 08:10 PM

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