Excel X - unlock cell

G

Gary

In past versions of Excel I could unlock a set of cells, then protect the
worksheet and only the unlocked cells could be changed by the user. This
does not seem to be available in Excel X. In the Format Menu there is no
option to select a cell or cells to unlock them. Any ideas?
 
B

Bob Greenblatt

In past versions of Excel I could unlock a set of cells, then protect the
worksheet and only the unlocked cells could be changed by the user. This
does not seem to be available in Excel X. In the Format Menu there is no
option to select a cell or cells to unlock them. Any ideas?
Click to expand...
It works fine. Select the cells, and choose format-cells and go to the
protection tab. Set the protection and then protect the sheet.
 
K

Kenji

Should have no problems. Try again.

In past versions of Excel I could unlock a set of cells, then protect the
worksheet and only the unlocked cells could be changed by the user. This
does not seem to be available in Excel X. In the Format Menu there is no
option to select a cell or cells to unlock them. Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Excel does not accept text format! 0
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Override protected sheet message? 4
Protect locked cells (only) from formatting? 4
Locked cells are still able to be selected with proper protection 1
Excel 2000 help please - Cell protection 2
Excel 2000 cell format of unlocked cells in aprotected sheet 1

Top