Activex controls in Excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Or through VBA.

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

Substitue your sheet name for "Sheet1" and whatever your control name is for
"CommandButton1".
 
You must log in or register to reply here.

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

Convert VB6 ActiveX Control to VB.NET And Incorporate it Into ASPX 0
ActiveX Control text box 6
Definitions for Activex control properties? 2
Signed and Unsigned ActiveX Controls 2
Help needed with MS patch KB891781 and ActiveX controls 3
Excel Referencing one cell from a different worksheet and slide in powerpoint 0
Problem with ActiveX control 1
ActiveX Combobox and LinkedCell 2

Back
Top