Syntax for de-selecting a control?

[William DeLeo]

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

[Jim Cone]

Billy
,
This ought to work...

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

Regards,
Jim Cone
San Francisco, USA


"William DeLeo" <[email protected]>
wrote in message news:[email protected]...
>
> 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

[William DeLeo]

Hey Jim ... thanks for the reply.


I tried that originally, and once again just now, and I get the follwoing error message:

Runtime error "438"

Object doesn't support this property or method.

Are you sure that works?

Billy

[William DeLeo]

nobody has this answer?