+ Reply to Thread
Results 1 to 8 of 8

Link to background image rather than embed?

  1. #1
    Registered User
    Join Date
    09-20-2014
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    98

    Link to background image rather than embed?

    Hi there

    I have looked around and not found an answer to this.

    Is there any way of linking to a background image rather than have to embed it on every worksheet?

    As my workbooks often contain 25 - 30 worksheets, it makes the file pretty hefty.

    Thanks


  2. #2
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Link to background image rather than embed?

    Can you upload the workbook with 3 sheets where 1 sheet have the background image.....
    Lokesh Kumar
    Stay Hungry.. Stay Foolish..
    _________________________________________________________
    Please Click STAR to Add Reputation if my/someone's answer helped!

  3. #3
    Registered User
    Join Date
    09-20-2014
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    98

    Re: Link to background image rather than embed?

    Here ya go

    Thanks for you support

    Y3unlocked.xlsm

  4. #4
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Link to background image rather than embed?

    Is there any way of linking to a background image rather than have to embed it on every worksheet?
    Where is the image can you define that........Embed Object.png

  5. #5
    Registered User
    Join Date
    09-20-2014
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    98

    Re: Link to background image rather than embed?

    Sorry I uploaded the wrong file - ha.

    This one is correct. The VBA fails, but you get the idea....

    sample.xlsm

  6. #6
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Link to background image rather than embed?

    Hi,
    This was your primary question.....
    Is there any way of linking to a background image rather than have to embed it on every worksheet?
    I guess you are looking for something else...
    But again I am not able to see the image.....here you have some table formatting with background "Blue color" and the worksheet is locked....

  7. #7
    Registered User
    Join Date
    09-20-2014
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    98

    Re: Link to background image rather than embed?

    There is an image on all 3 worksheets in the sample.xlsm It has been embedded using the Background menu option.

    This is the image.....

    1.jpg

  8. #8
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Link to background image rather than embed?

    Hi,
    You can use the following code if you are inserting this from a image.....Insert Background.xlsm

    Please Login or Register  to view this content.
    If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped 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. linking to background image rather than embed?
    By dazbear in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2015, 02:24 PM
  2. [SOLVED] Image Embed into a Shape from a URL?
    By bmasella in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-28-2014, 03:18 PM
  3. [SOLVED] Embed image to button using Image control
    By siobeh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-12-2014, 05:37 PM
  4. Embed Image JPG and Type Over it.
    By WileECoyote in forum Excel General
    Replies: 1
    Last Post: 04-06-2011, 07:52 AM
  5. Embed image in cell
    By AceX in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2008, 02:33 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