+ Reply to Thread
Results 1 to 6 of 6

Print pictures which are comments

  1. #1
    Registered User
    Join Date
    01-31-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    1

    Print pictures which are comments

    Can anyone help? I have lots of pictures in comments boxes and I want to print them all after the rest of the spreadsheet, but Excel will only print text comments from comment boxes. Is there a macro I can use or a solution to this? Thank you!

  2. #2
    Valued Forum Contributor
    Join Date
    07-29-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2003/Excel 2010
    Posts
    534

    Re: Print pictures which are comments

    Normally i don't show off my feeble VBA efforts, but since nobody answered your question.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-22-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Print pictures which are comments

    Quote Originally Posted by WHER View Post
    Normally i don't show off my feeble VBA efforts, but since nobody answered your question.
    Very nice, thank you. Works wonderously

  4. #4
    Registered User
    Join Date
    04-28-2014
    Location
    Bethlehem, PA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Print pictures which are comments

    Quote Originally Posted by WHER View Post
    Normally i don't show off my feeble VBA efforts, but since nobody answered your question.
    Help please! I have an excel file for a construction project "pictorial" punch list. I've added the pictures as comments to each respective punch list item (row), however, users will need to be able to print the list with the pictures. I'm no expert in VBA or Macros - but I managed to copy the VBA script from the file provided in this thread, and made some minor adjustments to the cell numbers/ranges to coincide with my file. The spreadsheet prints using the macro but the pictures are not printing. Any suggestions? What does the "If Type = 4" signify?

  5. #5
    Registered User
    Join Date
    09-08-2014
    Location
    Buffalo, United State of America
    MS-Off Ver
    offce 2010
    Posts
    1

    Question Re: Print pictures which are comments

    Hi, liked your post only I am having a little bit of a problem. The images that I am scanning are actual standard one page reports which I would like to print up at the end of the report. The macros work wonderfully but I would need to adjust the size to reflect the actual size of the report. Is there a fix for this?

  6. #6
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,108

    Re: Print pictures which are comments

    dmmtech,
    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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