I created a knowledge base that uses a drop-down list to copy/paste data from another location. It's a simple macro. I have embedded images into comments to make it simple to pull images and paste them with a proper format.
The problem is, the sheet will only work on my computer and breaks as soon as I save it. When I save, I get a Privacy Warning.
Once I save and re-open the file, I get these errors:
"Excel found unreadable content...do you want to recover? Y/N
"Excel was able to open the file by repairing or removing the unreadable content."
Removed Part: /xl/drawings/vmldrawings1.
vml part. (Drawing Shape).
Then, when the file reopens, the macro doesn't work, and, none of the embedded images from the comments appear.