ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Activex controls in Excel 2003 (https://www.excelbanter.com/excel-worksheet-functions/138325-activex-controls-excel-2003-a.html)

Tom Stewart

Activex controls in Excel 2003
 
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?

William Horton

Activex controls in Excel 2003
 
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

"Tom Stewart" wrote:

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?


William Horton

Activex controls in Excel 2003
 
Or through VBA.

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

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

"Tom Stewart" wrote:

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?



All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com