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.