Set picture box to change pic and reset code to do it again on click

**Taemex** · 06-11-2013, 06:32 PM

I've been using this code for months without any problems when suddenly, it stopped working and I really can't figure out what has changed because I didn't alter the code... I downloaded the latest Visual Studio's update and now it's not working... Anyways, it's for an Excel 2003 Macro that, when you click on the picture, allows you to select a new picture from your computer, resizes it to fit in a specific area, then gives the new picture the original code to do it all over again. Trouble is, it suddenly stopped working and I now get this error:

Run Time Error '1004':

Unable to set OnAction property of the Picture class

Here is the picture code:

Please Login or Register  to view this content.

I didn't write this code. On debug, it tells me this is the error code: myPict.OnAction = "'" & ThisWorkbook.Name & "'!NewInsertMacro"
But like I said, it has worked for months, maybe even over a year without any issues, then suddenly when I download Visual Studios update since I upgraded from Express to the full version of Visual Studios, this code does not work and keep returning that error message. I tried selecting pictures from different areas, different type pictures, everything I can think of. I really don't have any idea what the problem might me. Any help much appreciated.

BTW, I posted this on VBForums, but so far they can't figure it out.

**Taemex** · 06-12-2013, 12:54 AM

I found the problem. It was actually super easy. I feel very stupid. I recently put my file inside a folder with brackets "[]" and apparently opening these types of files makes Excel have a heart attack. I figured this out when trying to assign manually re-assign my macro back to the pic only to get an error message about the formula being too complex, then looking that up on the net and finding out that meant my excel workbook was inside a folder with special symbols (which is was), at which point I moved it out and everything worked fine. I wonder if there is a way to check for error codes in VBA so I can catch this as an exception instead of entering Debug mode, which casual users would be totally stumped if they saw. But then again, casual users probably won't need to separate their folders with hash tags and brackets to identify them.