+ Reply to Thread
Results 1 to 2 of 2

Comment Arrows Need to Disappear or Be Covered Up

  1. #1
    Registered User
    Join Date
    06-25-2013
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    10

    Comment Arrows Need to Disappear or Be Covered Up

    I am using the Excel comments as a very nifty way to have pictures automatically come up based on a drop down and some VBA code. The comments must always be shown and the .jpg files automatically load onto each respective page.

    The only problem is that the comments have an arrow pointing from the comment box to the cell that it originates from. In my particular case the picture, or comment box, needs to be placed somewhat far away from where the dropdown originates. Therefore, the arrow shows up and it is ugly.

    I have done a big search and there seems to be no way to rid of the arrow alone. My best try to alleviate this was to place an object over the arrow covering it up. I made the rectangle white, but it appears that the comment arrow always goes to the front. My current fix is to place a box above it, but I am making the box all black. It actually looks decent on the screen but printing with that much black will not be great.

    I am open to any suggestions and/or VBA code that might fix this situation. Thank you very much in advance.

    Zachary

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Comment Arrows Need to Disappear or Be Covered Up

    If you put the comment's top left corner immediately to the right of the cell, you won't see the arrow.
    Entia non sunt multiplicanda sine necessitate

+ 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] How to find out if a specific date is covered?
    By simonelvin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-30-2013, 07:35 AM
  2. Increase thickness of arrows in comment boxes?
    By Marvlin in forum Excel General
    Replies: 0
    Last Post: 07-28-2013, 02:46 PM
  3. Disable Delete Comment, Edit Comment, Show/Hide Comment
    By Shanthan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2013, 06:12 AM
  4. Replies: 4
    Last Post: 04-15-2013, 11:20 AM
  5. [SOLVED] How do I find columns that I covered up?
    By Steph K in forum Excel General
    Replies: 1
    Last Post: 03-21-2006, 04:40 PM

Tags for this Thread

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