+ Reply to Thread
Results 1 to 2 of 2

Editing unlocked cells in locked form Excel file

  1. #1
    Registered User
    Join Date
    06-24-2009
    Location
    Colchester, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Editing unlocked cells in locked form Excel file

    Hi,

    I have created a basic form in Excel, locking all the cells that I do not want edited, and unlocking all the cells that I do want editing.

    All locked cells have been "hidden" too, as some contain formulas that update when the unlocked cells have information in them, mostly numbers.

    I have locked the WorkBook and locked the sheet. The form works absolutely fine, how I want it to.

    All except one thing. I have googled this extensively and can find no help at all.

    After I have input text into one of the unlocked cells, let's call it A1, when I tab to the next cell, let's call it A2, this is fine. A1 retains the text that I input into it. If I notice a mistake in A1, when I click into the cell to edit, it removes all previous data.

    If I had input 200 words into cell A1, and wanted to edit 1 word, I cannot. Because as soon as I click A1 again, it removes everything to a blank cell.

    You cannot edit in the cell or on the formula bar.

    Can anyone help me? It is driving me to distraction.

  2. #2
    Registered User
    Join Date
    06-24-2009
    Location
    Colchester, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Editing unlocked cells in locked form Excel file

    Have answered my own question!

    If you experience this, make sure that the field is not "Hidden". Right click the cell, click Format Cell. Go to the Protection tab and uncheck "Hidden".


+ 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