+ Reply to Thread
Results 1 to 3 of 3

Can't edit cells after unprotecting and unlocking the workbook

  1. #1
    Registered User
    Join Date
    04-19-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    11

    Unhappy Can't edit cells after unprotecting and unlocking the workbook

    I have created a workbook and locked all cells with formula and protected it with a password. Then I found out that I made an error and had to change one of the formula. I unprotected the workbook first then unlocked all the cells. However, it still won't let me edit the cell. Anyone how to fix this problem???

  2. #2
    Registered User
    Join Date
    09-26-2012
    Location
    Idaho, USA
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Can't edit cells after unprotecting and unlocking the workbook

    Double check to make sure it is unlocked in all areas. At the bottom right click sheet, check there, under Review and protect sheet there and then click your cell right click for "format" then click on the tab protection. Make sure it is unlocked there.

  3. #3
    Registered User
    Join Date
    04-19-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Can't edit cells after unprotecting and unlocking the workbook

    I used Ctrl+A to select the whole worksheet, everything is unprotected and unlocked but won't let me edit the formula....

+ 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] Unlocking Workbook
    By mike02 in forum Excel General
    Replies: 2
    Last Post: 07-16-2012, 02:59 PM
  2. protection of a workbook + unprotecting specific cells + calculation auto
    By choubix in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2008, 07:49 AM
  3. unlocking a cell to edit it
    By dude2007 in forum Excel General
    Replies: 9
    Last Post: 02-22-2008, 04:02 PM
  4. Unlocking a workbook
    By Audubon in forum Excel General
    Replies: 7
    Last Post: 08-24-2005, 11:05 AM
  5. [SOLVED] can't format cell - have tried unlocking and unprotecting
    By griffin in forum Excel General
    Replies: 1
    Last Post: 04-04-2005, 10:06 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