You could set it each time the workbook opens (with macros enabled):

Option Explicit
Sub auto_open()
Dim wks As Worksheet
Set wks = Worksheets("sheet1")
With wks
.Select
.Protect
.EnableSelection = xlUnlockedCells
End With
End Sub



andremations wrote:

Hi All,

Is there a way to save the EnableSelection property of a sheet? Because
whenever I open a saved sheet after I have changed the EnableSelection
property from 0-x|NoRestrictions to 1-x|UnlockedCells the property
always changes back 0-x|NoRestrictions. Thanks in advance.

Andre

--
andremations
------------------------------------------------------------------------
andremations's Profile: http://www.excelforum.com/member.php...o&userid=28688
View this thread: http://www.excelforum.com/showthread...hreadid=484307

--

Dave Peterson