Help with broken Macro


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 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.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NorieAnalyst Assistant Commented:
Goto the Developer Tab, click Macro Security, goto Privacy Warnings and uncheck 'Remove personal information....

You can also go via Files>Options>Trust Center Settings...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
nomiosAuthor Commented:

This got rid of the privacy error that I saw when I saved. However, I still get the same errors when I open the file--and none of the comments with pictures are there.
NorieAnalyst Assistant Commented:
Well I don't get any errors, but I'm not sure what you mean by 'comments with pictures.

The only pictures in the attached workbook are the phone and laptop which are on both Main and Product1.

That's before I change anything in the workbook or save it.
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

nomiosAuthor Commented:
You can't see them because when I save and re-open it--that information is gone. I'm guessing that's why I get errors when opening the file.

Here's the process I'm using to embed pictures into comments:
NorieAnalyst Assistant Commented:
I haven't saved the workbook, I just opened it.
nomiosAuthor Commented:
I'm having the same problem listed here:

I can't find a solution...
NorieAnalyst Assistant Commented:
That doesn't look like it's a macro problem, in fact I don't think the problem with the workbook is the macro.

Do you get any errors with it?
nomiosAuthor Commented:
Maybe it's not with the Macro--I'm just not sure how to fix it.
NorieAnalyst Assistant Commented:
I don't know either, perhaps if it was a macro problem I could help.

By the way, why are you using Excel for this?

Have you considered using some other application?
nomiosAuthor Commented:
I'm using Excel because I don't know of any other free applications that I'm familiar with that can do this sort of thing.
NorieAnalyst Assistant Commented:
Excel isn't free.

I was thinking of something like Access or Word, or you could even create a small HTML 'site' - now that would be free.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.