Help on printing only selected hyperlinked documents in Excel using VBA
 

I am trying to allow the users to select from a large list of project
summary sheets which sheets they would like to send to the printer when they
press the "Print PSS" button. They can indicate this either by putting a 1
in the "Print?" column, or something along those lines. Each project
summary sheet is a hyperlinked word document. So, I need to go through the
entire list, check which ones has a 1 in the "Print?" column, and then send
those documents that are behind the hyperlink to the printer. Any ideas as
to how this can be done with some VBA code?

Example:





Print? Project Name Country
Open Project Summary Sheet Something Malawi
Open Project Summary Sheet Something Kenya
Open Project Summary Sheet Something Kenya
Open Project Summary Sheet Something Pakistan
Open Project Summary Sheet Something USA
Open Project Summary Sheet Something Iceland
Open Project Summary Sheet 1 Something Iceland
Open Project Summary Sheet Something Norway
Open Project Summary Sheet Something Germany
Open Project Summary Sheet Something Something
Open Project Summary Sheet Something Something
Open Project Summary Sheet Something Something
Open Project Summary Sheet 1 Something Something
Open Project Summary Sheet Something Something
Open Project Summary Sheet Something Something
Open Project Summary Sheet Something Something
Open Project Summary Sheet Something Something
Open Project Summary Sheet 1 Something Something
Open Project Summary Sheet Something Something
Open Project Summary Sheet Something Something


Regards,

Lars