image & picture

[Guest]

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

 

[Tom Ogilvy]

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.

 

[Guest]

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