Print pictures which are comments

**antonianjackson** · 01-31-2011, 10:02 AM

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!

**WHER** · 02-01-2011, 12:47 PM

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

**safmy** · 11-05-2013, 05:28 AM

Originally Posted by WHER

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

Very nice, thank you. Works wonderously

**VRIVAS** · 04-29-2014, 04:18 PM

Originally Posted by WHER

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?

**dmmtech** · 09-08-2014, 11:35 AM

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?

**protonLeah** · 09-08-2014, 04:45 PM

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.