Excel: Multiple Levels of Protection

Question

When protecting a sheet in Excel, the attached dialogue box appears, demonstrating the various possible protections that can be applied.
Excel protection dialogue

I have three types of cells in my workbook:
a) Cells that I don't want the user to be able to select (the vast majority).
b) Those that I want the user to be able to select, but not to edit (just one or two).
c) Those that I want the user to select and edit (a few).

However I don't seem to be able to protect cells differently; it seems that you pick the rules once, and they then apply to all protected cells. Is there a way around this? Perhaps using VBA?

Thank you.

Thanks @DonkeyKong but the ability to let users edit cells isn't the problem, it's the selection; I need them to only be able to select a handful of cells, and then only edit a subset of those. — J Brazier

kujiy kujiy · Accepted Answer · 2016-01-20T10:28:29

Perhaps this helps you a little. Try this;

Open your .xls(x) file
Open VBA editer with pressing Alt+F11
W-click a sheet name and paste below;

Sub unprotect()
    ActiveWorkbook.ActiveSheet.unprotect
End Sub
Sub protect()
    ActiveWorkbook.ActiveSheet.protect
End Sub

Back to your sheet window and press Alt+F8 and execute subs.

Excel: Multiple Levels of Protection

1 Answers