what is enableselection proprty does?
Did you also protect the sheet after?
From Help on "enableselection"
This example sets worksheet one so that nothing on it can be selected.
With Worksheets(1)
.EnableSelection = xlNoSelection
.Protect Contents:=True, UserInterfaceOnly:=True
End With
Gord Dibben MS Excel MVP
On Mon, 23 Oct 2006 12:19:02 -0700, Dev wrote:
I changed the value of this property to xlnoselection but nothing happened. I
am wondering what this property does.
|