| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question regarding an activex control button
Thanks David..That did it!
"David Fixemer" wrote in message ... Slim, Used my VBA recorder to generate the following code: ActiveSheet.OLEObjects.Add ClassType:="Forms.CommandButton.1", Link:=False _ , DisplayAsIcon:=False, Left:=171, Top:=51.75, Width:=46.5, Height:= _ 22.5).Select With Selection .Placement = xlMoveAndSize .PrintObject = True End With The key line is: selection.placement = xlMoveAndSize David Fixemer |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
| How to create control button on worksheet: Forms v. ActiveX feature? | Excel Discussion (Misc queries) | |||
| Hyperlink added to an activex control button | Excel Discussion (Misc queries) | |||
| ActiveX Control Button | Excel Programming | |||
| Control button question | Excel Programming | |||
![slim[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
