Insert picture macro doesn't work in Excel 2007

**bren21171** · 03-05-2009, 02:16 PM

Help

I just upgraded to Excel 2007 and my macro from Excel 2003 for inserting a picture doesn't work correctly in 2007. I have a command button that states insert picture and when you click it, it will let you insert a picture into the cell and hide the command button. In 2007 it will let you insert the picture, but it isn't centered and expands into other cells and the command button is still visible. The picture appears to be the correct size it just doesn't center itself in the cell and the command button is still visible. Below is the code, Help me please!

Please Login or Register  to view this content.

**michelxld** · 03-05-2009, 04:21 PM

Hi,

you may adapt like this :

Please Login or Register  to view this content.

Regards
michel

**jolivanes** · 03-05-2009, 07:08 PM

I am, and will be for a while, away from my "information about excel" files but check out the "GetOpenFilename". If I remember right, this is not supported in 2007. I have seen several workarounds for this on the forums.
Sorry I can't help anymore with this but I am sure you'll find it.

Regards.
John

Edit. I did not read properly I guess. You said that the GetOpenFilename works. Sorry about that.