Hi,
Does anyone know code that will update the recipe sheets with pictures?
Thanks
Hi,
Does anyone know code that will update the recipe sheets with pictures?
Thanks
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.
Thanks Glenn
My pleasure
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.
Last edited by mehmetcik; 03-02-2020 at 01:44 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
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.
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.
I tried your version and it has some bug after pasting pictures.
Thanks for trying I do appreciate any help.
hm, is it the same issue? https://www.excelforum.com/excel-for...cipe-name.html
I marked it solved I just thought he wanted to try another solution.
Thank you BMV your code is best!
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)
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks