0

In a sheet (named "JE") I have two columns E & G that have formulas in them and want to ONLY lock those columns. When I try to click format --> Lock Cells then protect the sheet, it protects all of the columns. Is there a way through the front end in excel or VBA, where I can only lock those two columns and that's it?

The version I am working with is MS Excel 2016.

Thanks!

Improve this question
4
  • What version of Excel? Feel free to update your question with this as it could effect the steps to accomplish.
    – Cheesus Crust
    Aug 1, 2017 at 18:32
  • @CheesusCrust I have updated my question with the version I am working with. Thanks
    – anve
    Aug 1, 2017 at 19:22
  • 1
    Just select ALL the cells in your sheet, untick "Locked" on them, then re-tick "Locked" on the cells you want to protect and protect the sheet. (Every version of Excel I've used has had "Locked" ticked by default in the standard blank workbook.)
    – Tim Joy T-Square Consulting
    Aug 2, 2017 at 3:00
  • @tjejojyj when I highlight the cells in columns E & G that I want to lock, I go to format, format cells, check "locked" then I protect the sheet. After I protect the sheet, I want to be able to edit column F but when I try, I get an error message saying that the sheet is protected and I can't click into that cell. How can I lock just the E & G columns, and that's it?
    – anve
    Aug 2, 2017 at 13:20

1 Answer 1

Reset to default
0

Select ALL the cells in your sheet, untick "Locked" on them, then re-tick "Locked" only on the cells/columns that you want to protect and protect the sheet.

(Every version of Excel I've used has had "Locked" ticked by default in the standard blank workbook.)

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .