Activex controls in Excel 2003

T

Tom Stewart

I can't see the activex controls embedded in a worksheet - they're present
because I can click on them but they don't show on the sheet. How do I make
them visible?
 
W

William Horton

Do this not through VBA.
Activate the sheet that the activex control is on. Pull up the controlbox
toolbar. Click on the design mode icon (to enter design mode). The control
should now be viewable. Right-click on the control and choose Properties.
Change the visible property to True.

Hope this helps.

Bill Horton
 
W

William Horton

Or through VBA.

Worksheets("Sheet1").CommandButton1.Visible = True

Substitue your sheet name for "Sheet1" and whatever your control name is for
"CommandButton1".
 
Top