Partially Lock Workbook

[Darko_Giac]

Hi all,

I'm wondering whether there is a way to partially lock a workbook.

I've created an excel file with a drop down list containing formulas, and was trying to figure out whether there is a way to partially lock the workbook so that respondents can still edit/fill in every cell EXCEPT for the ones containing formulas.

Thanks!

Darko

[AliGW]

Yes - you need to set those cells you want to be editable not to lock (right-click - format - security), and then protect the worksheet (Review ribbon).

[Darko_Giac]

Perfect, thank you!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.