View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Josh Sale Josh Sale is offline
external usenet poster
 
Posts: 177
Default Filling command button with image

My Excel 97 - Excel 2003 program creates a small Forms.CommandButton on
worksheets. The command button has no caption but I want to fill as much of
the button face with an image as possible.

I use code like the following:

myBtn.Object.Picture = LoadPicture("myImage.gif")

I've tried creating the image as a GIF, BMP or JPG and I always get the same
result ... a small image centered within the button. I can't fill the whole
button face with the image the way I want.

I've tried setting PicturePosition = fmPicturePositionCenter and that
doesn't help. I've also tried setting PictureSizeMode but that property
doesn't seem to be supported.

Any suggestions?

TIA,

josh