| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programmatically determine if a control is .VISIBLE or not.
How does one determine if a control (button) on a command bar (toolbar) is visible or not so it can be acted upon for an IF...THEN statement?
This bit works if the control is visible: Visible = Application.CommandBars("PivotTable").Controls("Re fresh All").Visible If the control is not visible then I get the following error: Run-time error '5': Invalid procedure call or argument TIA! Toby Erkson Oregon, USA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Control which option is visible in Combo boxes | Excel Programming | |||
| Excel - adding control programmatically. | Excel Programming | |||
| Is it possible to change the Input Range of a Form Control programmatically? | Excel Programming | |||
| Spin32.ocx control tab not visible | Excel Programming | |||
| Keep userform visible, but return control to calling routine | Excel Programming | |||
Threaded Mode
