Only print comments if specific cell within same row>0

Your macros are in a different file (Detail Est 01-10-10er.XLT) so I can't see what they do. I would suggest you put these macros directly into the file that will be using them.

At any rate, one solution would be to write VBA code to print the desired comments to another sheet, and print that sheet. Excel does not support selecting comments for printing at the comment level.

If you create another worksheet called Comments, this code will make a pass through your data and put the desired comments on that sheet. You can then print that. This solution is very specific to your situation.

Please Login or Register  to view this content.