LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default image & picture

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show picture with transparencies in Image Jens Meier Excel Programming 5 August 9th 05 02:53 AM
Charts to Image or Picture? Bill Elerding Charts and Charting in Excel 2 May 5th 05 12:54 PM
Copy picture from image control Ian[_14_] Excel Programming 4 February 8th 05 02:48 PM
userform image from picture in worksheet Doug Glancy[_5_] Excel Programming 2 November 10th 03 04:43 AM
VBA : A picture from http://.../Image.gif VUILLERMET Jacques Excel Programming 2 October 1st 03 09:24 PM


All times are GMT +1. The time now is 07:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"