+ Reply to Thread
Results 1 to 5 of 5

Inserting a comment/text box to a picture (excel 2007)

  1. #1
    Registered User
    Join Date
    07-18-2012
    Location
    Southampton, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Inserting a comment/text box to a picture (excel 2007)

    I'm trying to attach comment/text boxes to pictures or shapes on excel, so it pops up when you click on the picture (like it does when a comment box is attached to a cell).

    I need to attach it to the picture not the cell, so it will move with the picture.

    I would be very very grateful if any one knows how to do this and wouldn't mind sharing their knowledge with me

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

    Re: Inserting a comment/text box to a picture (excel 2007)

    You will need to write VBA to have a shape/picture display extra commentary.

    See attached.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    07-18-2012
    Location
    Southampton, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Inserting a comment/text box to a picture (excel 2007)

    Thanks for sending that Andy!

    I'm having a few problems opening the document though.

    When I open the document i get the following messeage:

    846198[1].xlsm is locked for editing by 'another user'

    So I choose 'read only' to open the document, then when I click on the shape, I get the following message:

    Cannot run the macro "C:\Documents and Settings\lingard\Local Settings\Temporary Internet
    Files\Content.IE5\I2AGCPQI\846198[1].xlsm'DisplayExtraComment'. The macro may not be available in this workbook or all macros may be disabled.

    I have checked, and I have all macros enabled under macro security.

    Do you know what the problem might be?
    Apologies for my lack of knowledge, it's probably something simple!?

    Thanks

    Louis

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

    Re: Inserting a comment/text box to a picture (excel 2007)

    Start by saving the attachement to a folder and then opening it in excel.

  5. #5
    Registered User
    Join Date
    07-18-2012
    Location
    Southampton, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Inserting a comment/text box to a picture (excel 2007)

    Thanks Andy, very kind of you to give up your time to help!

+ 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