Copying an image - Excel VBA
I hate to say this, but I think you have painted yourself into a corner on this one. Excel's objects do not support modifying picture data in the way you describe, which means that you cannot make these changes while the sheet is open. Even if you figured out how to make changes to the raw file, it does not satisfy your UI requirements.
Your workaround is probably your best (Excel-based) answer.