I changed the value of this property to xlnoselection but nothing happened. I
am wondering what this property 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.

EnableSelection takes effect only when the worksheet is protected. It
prevents you from selecting cells.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)

"Dev" wrote in message
...
I changed the value of this property to xlnoselection but nothing happened.
I
am wondering what this property does.

Just to add,
with a worksheet selected, make the control toolbox toolbar visible. click
on the properties button. (it is usually the second button on the top row).
One of the properties is EnableSelection. It is the VBA equivalent manage
the setting for this property.

--
Regards,
Tom Ogilvy



"Dev" wrote:

I changed the value of this property to xlnoselection but nothing happened. I
am wondering what this property does.