![]() |
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? |
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? |
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