| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax for de-selecting a control?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the syntax for control+UpArrow in Macro? | Excel Discussion (Misc queries) | |||
| Syntax for control source in combo box control | Excel Discussion (Misc queries) | |||
| macro syntax for selecting variable range | Excel Discussion (Misc queries) | |||
| Syntax for selecting a textbox within a chart? | Charts and Charting in Excel | |||
| Syntax to return the value of a control by reference | Excel Discussion (Misc queries) | |||
Threaded Mode
