Hi guys, I need your help once again!
I have a macro which adds pictures onto a worksheet but it is running into two problems.
Firstly, on my version of Excel (2013) the pictures are resized correctly and the aspect lock is removed. However, on my colleagues version of excel (2010) it seems to not be disabling the aspect lock. Is there a different command for it in 2010? My code is shown below:
Secondly, I seem to be having some issues once the picture is inserted. If I look at it on my laptop then the pictures appear but when the file is transferred to another laptop it does not seem to be taking the pictures with it? (I get an error message to say that the link is broken). How do I put the pictures in as pictures rather than just links to the pictures? My code for adding the pictures is shown below:Please Login or Register to view this content.
You guys have been mighty helpful in the past and I need some more now because I have been scratching my head for ages over this!Please Login or Register to view this content.
Thanks
Tom
Bookmarks