controlformat.enabled failed in excel macro

D

DAACKM

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?
 
D

Dave Peterson

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").Object.Enabled = False
 

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

Excel VBA - Problems using Protect/Unprotect a worksheet 3
Copying Worksheets in Different Books to One Workbook 2
Open second Excel file with VBA 5
how to execute a macro assigned to a checkbox in vba 4
How to call Excel add-in macro from a button… 1
To Enable Macro in Excel. 2
Unhide sheet, copy and rename new sheets from list, rehide sheet 8
Macro to copy from another workbook 1

Top