+ Reply to Thread
Results 1 to 3 of 3

Change Existing Macro to Allow Border to Show Around Images

  1. #1
    Registered User
    Join Date
    01-30-2014
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    22

    Change Existing Macro to Allow Border to Show Around Images

    Hi All!
    Thanks to Dave Peterson for writing the macro below - I found it on this forum and it's awesome!
    I was wondering if anyone has a suggestion for making the borders visible around the images that are inserted (via macro) into the workbook.
    I'm attaching the workbook I used the macro on - though I deleted anything I thought might be too sensitive to share as per the rules. (I also changed the macro from it's original (below) by changing the columns)
    Since you probably won't be able to view the images on the workbook, I'm also attaching a screenshot of what they look like.
    Thanks in advance!!
    Klotzy

    Testing Macro for Images 2.xlsx
    help.png

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Change Existing Macro to Allow Border to Show Around Images

    try adding 1 to the left/top properties and minus 2 from width/height
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-30-2014
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Change Existing Macro to Allow Border to Show Around Images

    Yes!
    Thanks!

+ 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] Add top and bottom border to existing code
    By guitarsweety in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2014, 01:55 PM
  2. Change an existing field to a calculated field using Show Values as
    By Excel_vba in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-16-2012, 01:50 PM
  3. Macro to change cell border colors from one color to another
    By Hanskubansku in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2012, 07:41 AM
  4. a macro to show all file details existing in a folder.
    By abhay_547 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2010, 09:59 AM
  5. Change cell border & outline in a macro
    By namz in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 06-07-2008, 03:59 AM
  6. Userform field to show existing string with ability to change.
    By Yappa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2008, 10:05 PM
  7. [SOLVED] Changing the border of one cell s/n change the border of adjacent
    By gjanssenmn in forum Excel General
    Replies: 2
    Last Post: 10-05-2005, 04:05 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