Solved Excel - Locking cells with formulas

October 14, 2011 at 13:17:19
Specs: Windows 7
Hi,

I'm using MS Excel 2010 and I need to lock a column of cells, say column B. Column B cells have formulas that change its value depending on column A cells. Cells on column A have specific values to be chosen, so they are in a list (data validation).

When I try going on Review tab and protect the selected cells (column B), I am unable to change values in column A. I want to be able to choose different values in column A to get different values in column B. I just needed the formulas in column B to be locked.

Is it possible?


See More: Excel - Locking cells with formulas

Report •

#1
October 14, 2011 at 14:31:46
How are you protecting "the selected cells (column B)"?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
October 17, 2011 at 06:05:19
Hi

I select the cells, go to the Review tab and click on "Protect Sheet".

I choose the "Protect worksheet and contents of locked cells" box and then the "Select locked cells" and "select unlocked cells" boxes.


Report •

#3
October 17, 2011 at 06:12:58
✔ Best Answer
By default, all cells in an Excel sheet are locked. However, being locked means nothing until the sheet is protected.

Once you protect the sheet, all cells are then locked and protected.

Allowing users to select locked cells is not the same thing as allowing them to change them.

If you want to allow users to change specific cells in a protected sheet, you need to unlock those cells and then protect the sheet.

Once you do that, the "unlocked" cells will not be protected.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
October 17, 2011 at 06:23:56
It works. Thanks a lot :)

Report •

Ask Question