Syntax for de-selecting a control?

  • Thread starter Thread starter William DeLeo
  • Start date Start date
W

William DeLeo

Greetings,

I figure this is a frequent question but I could not find a thread o
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 firs
place. Can someone suggest a way to disable this control and leave i
unselected (without selecting something else)?

Thanks in advance!

Bill
 
Billy
,
This ought to work...

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

Regards,
Jim Cone
San Francisco, USA
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"De"-select a forms control programmatically 4
shape remains selected 1
De-Select an Option button 3
De selecting a range after a copy and paste is performed 3
Set Enable = False without selecting? 3
VBA Help with changing shape color for selected shapes only 8
Can't get border on shape to deselect 2
get Control of a Butoon placed in the Sheet 2

Back
Top