| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ActiveX controls | Excel Discussion (Misc queries) | |||
| ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
| Help with Excel ActiveX listbox controls | Excel Discussion (Misc queries) | |||
| After installing Office XP SP3, Excel ActiveX controls are moved a | Excel Discussion (Misc queries) | |||
| Saving Excel with ActiveX controls | New Users to Excel | |||
Linear Mode
