Change default for protected sheets

C

carrera

The default is set at being able to access both locked and unlocked cells

How can I change this to allow access to only unlocked cells, without having
to unclick that option each time?

thanks
 
G

Gord Dibben

I just added a couple of buttons to a Toolbar and assigned these macros.

Sub SHEETPROTECT()
With ActiveSheet
.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
.EnableSelection = xlUnlockedCells
End With
End Sub

Sub SHEETUNPROTECT()
ActiveSheet.Unprotect Password:="justme"
End Sub


Gord Dibben MS Excel MVP
 
Top