[RESOLVED] excel protection question

If a sheet is protected, is it possible to disable selection / activation of locked cells?

first unprotect sheet

then format>sheet>unhide

for unprotecting sheet loads of code available ..use google.

Quote:

---

Originally Posted by indiewolf

first unprotect sheet

then format>sheet>unhide

for unprotecting sheet loads of code available ..use google.

---

Not sure what you mean. Are you referring to the format menu? The sheet is not hidden. As for unprotecting the sheet, I've got the line of code to do that.

To only allow the use to select/activate unlocked cells, use the EnableSelection property of the sheet before you cal the Protect method.

VB Code:

With ThisWorkbook.Worksheets(1)
        .EnableSelection = xlUnlockedCells
        .Protect Password:="declan"
    End With

Quote:

---

Originally Posted by DKenny

To only allow the use to select/activate unlocked cells, use the EnableSelection property of the sheet before you cal the Protect method.

VB Code:

With ThisWorkbook.Worksheets(1)
        .EnableSelection = xlUnlockedCells
        .Protect Password:="declan"
    End With

---

Thanks, do you know if this is going to work for Excel versions older than 2000 as well? I can't test it at the moment.

I've just tested it under Win98 / Excel 97 and it does work, so you can't disable locked cell selection by means of the Protect -> Sheet menu, but your code does the job.

Thanks again, DK.