View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Placement of graphical object on screen

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?
.