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

On Thu, 10 Jan 2008 09:26:07 -0800, carrera
wrote:

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