Set Enable = False without selecting?

[William DeLeo]

Hello all,

Can someone tell me how I can rewrite the following commands so tha
the control does not need to be selected to be disabled?

Thanks!


Sheets("Sheet Name").Shapes("Drop Down 3").Select
With Selection
.Enabled = False
End Wit

 

[kkknie]

Sheets("Sheet Name").Shapes("Drop Down 3").Enabled

 

[William DeLeo]

Thanks for the quick reply!

Q: That command will DIS-able the control or EN-able it?

I need to be able to do both ...

Thanks agai

 

[Juan Pablo González]

Actually, neither, you have to set it yourself:

Sheets("Sheet Name").Shapes("Drop Down 3").Enabled = False

or

Sheets("Sheet Name").Shapes("Drop Down 3").Enabled = True