| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
controlformat.enabled failed in excel macro
I have a form with a checkbox(enabled) and a scrollbar(disabled). The
checkbox is assigned to a macro which has the following line of code which is attempting to enable the scrollbar: ActiveWorkbook.Sheets(sheetname).Shapes(slidername ).ControlFormat.Enabled But when executed, I get "Enabled method of Scrollbar class Failed". The values for sheetname and slidername look OK. Any ideas? -- Dave Ackmann |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
controlformat.enabled failed in excel macro
If the scrollbar was from the Forms toolbar, I could use:
Worksheets("sheet1").ScrollBars("Scroll bar 1").Enabled = False If the scrollbar was from the Control toolbox toolbar, I'd use: Worksheets("Sheet1").OLEObjects("Scrollbar1").Obje ct.Enabled = False DAACKM wrote: I have a form with a checkbox(enabled) and a scrollbar(disabled). The checkbox is assigned to a macro which has the following line of code which is attempting to enable the scrollbar: ActiveWorkbook.Sheets(sheetname).Shapes(slidername ).ControlFormat.Enabled But when executed, I get "Enabled method of Scrollbar class Failed". The values for sheetname and slidername look OK. Any ideas? -- Dave Ackmann -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Reduce size of Macro Enabled Excel File | Excel Discussion (Misc queries) | |||
| Excel Macro-enabled Workbook | Excel Discussion (Misc queries) | |||
| Excel Macro-enabled Worksheet | Excel Discussion (Misc queries) | |||
| macro enabled excel worksheet running very slow. | Excel Discussion (Misc queries) | |||
| ThisWorkbook.Saved = True does not work when Shapes().ControlFormat.Enabled = False | Excel Programming | |||
Linear Mode
