+ Reply to Thread
Results 1 to 1 of 1

VBA to save or extract background image

Hybrid View

y5478882 VBA to save or extract... 12-15-2020, 08:53 PM
  1. #1
    Registered User
    Join Date
    08-12-2020
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    1

    VBA to save or extract background image

    I need to use VBA to save the background image out of excel sheets. I can us "ActiveSheet.SetBackgroundPicture Filename:=bgPath" to set a background picture, but can't find a function to extract or save it.

    I built an add-in that makes it easy to modify the colors of excel sheets. Part of that is creating a shape of selected color and setting it as a background image, which allows switching a sheet between "dark mode" and "light mode" without turning on high contrast. Everything works great, but I'm building an "invert colors" function and want to be able to invert the background image color. This isn't an issue when I set the background image and then invert in the same session as I can record the original color. Opening a saved file that already has the background set, however, requires me to extract the background image to invert the color.
    Last edited by davesexcel; 12-16-2020 at 07:55 PM.

+ 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. background image
    By gocolonel77 in forum Excel General
    Replies: 1
    Last Post: 07-30-2019, 10:54 AM
  2. Background image keeps disappearing!
    By dazbear in forum Excel General
    Replies: 0
    Last Post: 01-12-2015, 06:16 PM
  3. How to set Image in Background using URL
    By megel57 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-04-2013, 02:19 PM
  4. Image in the background
    By pdhawan in forum Excel General
    Replies: 3
    Last Post: 11-25-2011, 03:16 AM
  5. Background image
    By kenelder in forum Excel General
    Replies: 1
    Last Post: 10-31-2008, 11:50 AM
  6. Background image
    By beesus311 in forum Excel General
    Replies: 1
    Last Post: 02-23-2008, 10:57 AM
  7. [SOLVED] Excel Image Background
    By Steve in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2006, 12:40 AM

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