Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Quartz;
The example I'm giving you is for an image, but, if it is a button you can set the placement property the same way. ActiveSheet.Pictures.Insert( _ "C:\Documents and Settings\Administrator\My Documents\My Pictures\Sample.jpg"). _ Select Selection.ShapeRange.IncrementLeft 267# Selection.ShapeRange.IncrementTop 78.75 With Selection .Placement = xlFreeFloating .PrintObject = True End With Thanks, Greg -----Original Message----- Hello. I have a program that creates an activeX control on a sheet whenever a user clicks a button. The problem is, right now, the object is placed on the sheet at the cell pointer. I would like the object to always appear approximately center of the screen (doesn't have to be perfect) regardless of user location. Any clue how I can do this? . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I fix the position of an object on the screen? | Excel Discussion (Misc queries) | |||
How to add a screen tip to an object (no a hyperlink)? | Excel Discussion (Misc queries) | |||
Positioning a graphical object | Excel Programming | |||
determining coordinates for screen placement of user form | Excel Programming | |||
Keep Object with Focus on Display Screen | Excel Programming |