+ Reply to Thread
Results 1 to 3 of 3

How to "Glue" an object icon to a cell?

  1. #1
    Registered User
    Join Date
    06-08-2004
    Posts
    2

    How to "Glue" an object icon to a cell?

    I have a spreadsheet that is constantly updated and sent via email.
    In this spreadsheet I have imported some objects (as icons) such as mail messages and pics (screenshots) when I want to give more info about an issue in a specified cell.
    The problem is that the icons are not "glued" to any specific cell, so if I set a filter, the icons are everywhere.
    Is it possible to "glue" this icons to a cell?

  2. #2
    Dave Peterson
    Guest

    Re: How to "Glue" an object icon to a cell?

    Untested...

    Make sure that the icon is completely within the cell--no overlapping borders.

    Right click on that object
    choose format object
    Properties tab|check move and size with cells



    ludahen wrote:
    >
    > I have a spreadsheet that is constantly updated and sent via email.
    > In this spreadsheet I have imported some objects (as icons) such as
    > mail messages and pics (screenshots) when I want to give more info
    > about an issue in a specified cell.
    > The problem is that the icons are not "glued" to any specific cell, so
    > if I set a filter, the icons are everywhere.
    > Is it possible to "glue" this icons to a cell?
    >
    > --
    > ludahen
    > ------------------------------------------------------------------------
    > ludahen's Profile: http://www.excelforum.com/member.php...o&userid=10392
    > View this thread: http://www.excelforum.com/showthread...hreadid=539836


    --

    Dave Peterson

  3. #3
    Registered User
    Join Date
    06-08-2004
    Posts
    2

    It works

    Quote Originally Posted by Dave Peterson
    Untested...

    Make sure that the icon is completely within the cell--no overlapping borders.

    Right click on that object
    choose format object
    Properties tab|check move and size with cells



    ludahen wrote:
    >
    > I have a spreadsheet that is constantly updated and sent via email.
    > In this spreadsheet I have imported some objects (as icons) such as
    > mail messages and pics (screenshots) when I want to give more info
    > about an issue in a specified cell.
    > The problem is that the icons are not "glued" to any specific cell, so
    > if I set a filter, the icons are everywhere.
    > Is it possible to "glue" this icons to a cell?
    >
    > --
    > ludahen
    > ------------------------------------------------------------------------
    > ludahen's Profile: http://www.excelforum.com/member.php...o&userid=10392
    > View this thread: http://www.excelforum.com/showthread...hreadid=539836


    --

    Dave Peterson
    Thanks Dave, this did the trick

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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