Billy
,
This ought to work...

Sheets("WS_12").Shapes("Drop Down 4").Enabled = False

Regards,
Jim Cone
San Francisco, USA


"William DeLeo"
wrote in message ...

Greetings,
I figure this is a frequent question but I could not find a thread or
site that gives me the answer so here goes ...
I am using the follwoing code to disable a control:

Sheets("WS_12").Shapes("Drop Down 4").Select
With Selection
Enabled = False
End With
But I need to deselect it after, or not select it at all in the first
place. Can someone suggest a way to disable this control and leave it
unselected (without selecting something else)?
Thanks in advance!
Billy