View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DAACKM DAACKM is offline
external usenet poster
 
Posts: 4
Default 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