I have a basic worksheet template that we use at work to document inspection reports for our servicing/repairs. The "original" version required users to resize the pictures every time - resulting in inconsistent sizes and sloppy formatting. The "improved" version by a predecessor of mine used buttons outside of pre-formatted merged cells of consistent size and spacing. However, the macros were each tailored to a specific destination cell, so the worksheets were loaded with macros for the multiple pages of photos we use to document a report. These had a frequent, nearly constant 'stuttering' effect, where excel would hang during the insert picture operation (triggered by the macro buttons) and we would have to press ESC to get out of it. Sometimes we would have to shut down excel via task manager. The workaround (of sorts) was to save the file after every 2-3 pictures, which improved the problem, but did not eliminate it.

Now, I have modified the macro to use a button in the same cell as the picture's destination, which takes the file down to a single macro, and greatly increases flexibility of the form as well. That code is below:

Please Login or Register  to view this content.
Unfortunately, we have an operation on a remote network that still has problems, even with the improvement. Our techs here in Portland don't have the stuttering/hanging issue, but the other users do.

We are all running Windows XP. Not my choice, nothing I can do about it. We are running Excel 2010.

Any suggestions would be appreciated. BTW, I have noticed that the remote operation does use much larger picture sizes/data (25-30% larger), and even though they are on a laggy network, they claim to have the same issue with the file even when the file and pictures are locally on the desktop instead of the network.

Thanks in advance,
WK