+ Reply to Thread
Results 1 to 12 of 12

Update Recipe Pictures With VBA

  1. #1
    Banned User!
    Join Date
    02-26-2020
    Location
    US
    MS-Off Ver
    2010
    Posts
    157

    Update Recipe Pictures With VBA

    Hi,

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

    Thanks

  2. #2
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    134

    Re: Update Recipe Pictures With VBA

    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.

  3. #3
    Banned User!
    Join Date
    02-26-2020
    Location
    US
    MS-Off Ver
    2010
    Posts
    157

    Re: Update Recipe Pictures With VBA

    Thanks Glenn

  4. #4
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    134

    Re: Update Recipe Pictures With VBA

    My pleasure

  5. #5
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,024

    Re: Update Recipe Pictures With VBA

    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.
    Attached Files Attached Files
    Last edited by mehmetcik; 03-02-2020 at 01:44 PM.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  6. #6
    Banned User!
    Join Date
    02-26-2020
    Location
    US
    MS-Off Ver
    2010
    Posts
    157

    Re: Update Recipe Pictures With VBA

    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.

  7. #7
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,024

    Re: Update Recipe Pictures With VBA

    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.
    Attached Files Attached Files

  8. #8
    Banned User!
    Join Date
    02-26-2020
    Location
    US
    MS-Off Ver
    2010
    Posts
    157

    Re: Update Recipe Pictures With VBA

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

    Thanks for trying I do appreciate any help.

  9. #9
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,240

    Re: Update Recipe Pictures With VBA


  10. #10
    Banned User!
    Join Date
    02-26-2020
    Location
    US
    MS-Off Ver
    2010
    Posts
    157

    Re: Update Recipe Pictures With VBA

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

    Thank you BMV your code is best!

  11. #11
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,240

    Re: Update Recipe Pictures With VBA

    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)

  12. #12
    Banned User!
    Join Date
    02-26-2020
    Location
    US
    MS-Off Ver
    2010
    Posts
    157

    Re: Update Recipe Pictures With VBA

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Hyperlinks From Pictures Sheet to Recipe Sheet
    By RChad in forum Excel General
    Replies: 2
    Last Post: 02-29-2020, 08:10 AM
  2. Output Txt file with recipe based on variable recipe entered into excel sheet
    By sdl2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-21-2019, 08:35 PM
  3. [SOLVED] Problem in getting complete recipe/ Comprehensive recipe
    By brandedadnan in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-24-2015, 06:28 AM
  4. Getting the whole recipe
    By brandedadnan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2015, 04:11 AM
  5. automatically update excel linked pictures/objects
    By Darkenergyz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2014, 07:38 AM
  6. Userform to update comments with pictures
    By Marco-Kun in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-17-2011, 08:12 PM
  7. New pictures dont update as expected
    By col12345 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2011, 04:12 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1