Protection of particular Elements in Excel
Posted on 2014-09-10
I'm trying to unprotect then protect a worksheet in Excel.
The elements that I would like the users to be able to use are:
Select unlocked items
The reason being that I have a form that opens when the user double clicks in a range and if I simply turn protection on they are unable to trigger the action to fire the open of the form (the double click).
One part of the code currently looks like this:
Dim myPassword As String
myPassword = "GHDORF"
Application.ScreenUpdating = False
If Range("OTHERACTIVITY").Value = True Then
Worksheets("ORF - Activities").Unprotect Password:=myPassword
I can't seem to work out how I set the property/elements as described above.
Any help would be awesome!