<div>
<div class="content wysiwyg-content">
I have an ActiveX control (scrollbar) on a worksheet. &nbsp;I want to reference it and set it's properties in my open.<br />
<br />
shouldn't I be able to:<br />
<br />
dim w as worksheet<br />
Set w = Worksheets(&quot;DTDASH&quot;)<br />
<br />
w.scroll1.max = ##<br />
<br />
what am I not doing.<br />
<br />
tnx experts
</div>
</div>


I have an ActiveX control (scrollbar) on a worksheet.  I want to reference it and set it's properties in my open.

shouldn't I be able to:

dim w as worksheet
Set w = Worksheets("DTDASH")

w.scroll1.max = ##

what am I not doing.

tnx experts

Access an Active X scrollbar programatically

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.