View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.