I have created a code to import a picture into a cell or merged cells and created a button for it. The code works, but i would like to know if it's possible to shrink the picture slightly so it fits within the cell as right now it cover's up the borders.
The code is
Please Login or Register to view this content.
It seems as though you've already set the width - so if the height is excessive then, since you've locked the aspect ratio, adjusting the height should fit - too bad you're using a merged cell - perhaps:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
That increases the picture not decrease which is what i'm looking for and this code works in a single cell as well, and it still goes over the border of the cell is there something i can do with the line - Scale it to fit the cell - to Scale it to fit inside cell. HA HA
How About????Please Login or Register to view this content.
BTW - The reason I stuck with 2003 so long and when I upgraded, I upgraded to 2010 was that 2007 screwed up my shapes.
I tried that before I responded, it does work but it doesnt center the pic so you can now see the bottom border but not the top and the width one doesnt work either
Re: import picture to fit in merged cell
try modifying this to meet your needs:
Please Login or Register to view this content.
it looks as though Jewel has your answer - all I can advise is to keep playing with it - good luck!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks