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
|