Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks for the quick response... it getting later over their for you...
Tried both 'Image' and 'Command button1'. It puts just a 'part' of the picture into either object. I tried 'auto sizing', fmPictureCenter, etc. All I get is 50% of the picture in the 'Image' and a tall sliver of the Picture in the 'command button'. The command button still has the 'text' showing, but only 10% of the picture next to it. Due to 10-14 pictures on a Sheet, I need only a Picture only (3) row high (with the width squared off ). Also I tried 'record macro' and none of the Paste commands showed the 'properties' commands. It appeasr to be a manual operation. Thanks "Tom Ogilvy" wrote: select the picture and do Edit=Copy go to the image control in design mode and select propeties. click in the picture property and do Ctrl+C If you don't see it in the image control, then size it. You can do the same with a commandbutton. -- Regards, Tom Ogilvy "Tom Rudski" wrote in message ... I import a web picture into a Sheet and name the Shape (jpgname). I currently use Hyperlink to activate the Picture,that works. I have tried se;ecting & copying the Shape and pasting onto/inot a command button or image. Get errors running teh code. Can I make a command button or an image an paste the Shape(jpgname) into/onto the control button or image's face? I have read the previously posted responses to 'Picture' and they all Import a bmp file. I don't want to import a bmp file just assign an existing Sheets Shape to some type of command button/image. TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Show picture with transparencies in Image | Excel Programming | |||
Charts to Image or Picture? | Charts and Charting in Excel | |||
Copy picture from image control | Excel Programming | |||
userform image from picture in worksheet | Excel Programming | |||
VBA : A picture from http://.../Image.gif | Excel Programming |