+ Reply to Thread
Results 1 to 3 of 3

Copying worksheet to other workbook image is not copied to other workbook

  1. #1
    Registered User
    Join Date
    08-14-2018
    Location
    Belgium
    MS-Off Ver
    MS office 2010
    Posts
    2

    Copying worksheet to other workbook image is not copied to other workbook

    I'm trying to update the VBA in a great amount of the same kind of workbooks. I'm doing this by copying the content of the excel to an empty Excel with the updated VBA code in.
    The problem is that my image on a shape/button is not copied to the new workbook. Everything else is fine. How can I fix this?

    This is my code:

    Please Login or Register  to view this content.
    How it looks in excel.

    How it should look:
    goed.jpg


    How it looks after updating:

    fout.jpg

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Copying worksheet to other workbook image is not copied to other workbook

    Add code that re-assigns the image to that shape.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    08-14-2018
    Location
    Belgium
    MS-Off Ver
    MS office 2010
    Posts
    2

    Re: Copying worksheet to other workbook image is not copied to other workbook

    How do I re-assign the image to the shape?

    I tried this but the macro is not longer correctly linked to the button.

    Please Login or Register  to view this content.

+ 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. Copying part of a worksheet in one workbook to another workbook
    By j_Southern in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-04-2015, 09:00 PM
  2. Data will be copied from a separate workbook to worksheet RawData in another workbook
    By pghpens44 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2014, 10:07 AM
  3. [SOLVED] Copying Active Cell-Row-Range to Other Workbook is pasting an image of copied range
    By jrtraylor in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-18-2013, 01:08 AM
  4. [SOLVED] Copying worksheet from another open workbook using variables, paste to active workbook
    By sanpedro_nz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-08-2012, 08:25 AM
  5. Applying Copied Image to All Worksheets in Workbook.
    By Berdman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-24-2012, 09:41 PM
  6. [SOLVED] When Copying a sheet, the whole workbook gets copied
    By Rugby Al in forum Excel General
    Replies: 1
    Last Post: 01-04-2006, 09:10 PM
  7. Copying A Worksheet From Each Open Workbook to an new Workbook
    By carl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-03-2006, 01:40 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