Update Recipe Pictures With VBA

[RChad]

Hi,

Does anyone know code that will update the recipe sheets with pictures?

Thanks

[GlennUK]

You have code already ... just a couple of tweaks necessary, mainly to unprotect and reprotect the target sheets:

Please Login or Register  to view this content.

[RChad]

Thanks Glenn

[GlennUK]

My pleasure

[mehmetcik]

Hi Guys.

Does this code ( Based on Glens post #2 work?

I have been playing with this trying to learn.

I have made some changes to remove some errors.

Maybe you can use this.

Please Login or Register  to view this content.

[RChad]

It sort of works. It also pastes the green and red shapes to R-3 sheet. Those shapes have code to protect and unprotect sheets.

[mehmetcik]

Ok Guy.

I have had a play and this version is an improvement on the original.

Thanks for posting this. I learnt quite a lot.

[RChad]

I tried your version and it has some bug after pasting pictures.

Thanks for trying I do appreciate any help.

[BMV]

hm, is it the same issue? https://www.excelforum.com/excel-for...cipe-name.html

[RChad]

I marked it solved I just thought he wanted to try another solution.

Thank you BMV your code is best!

[BMV]

RChad. My post is not attempt to up my reputation but save you from mistake.
Read rules of forum
5. Do not open more than ONE thread per issue here. Expect duplicates to be closed. (B)

[RChad]

Okay very sorry I will not do that again. I just got caught up trying with formulas and code. This thread should be closed thank you.