Hello,

I know this will seem like a very basic question for all of you, but we currently have this sheet whereby once you click on a picture image it will come up with a selection box to choose where to output print (PDF, local printer, etc.).

The macro has apparently been designed to print every singly worksheet in the spread sheet.

However, when selecting the PDF output it misses off some of the worksheets and we don't know why.

Can someone tell me how to amend this or even just how to create a fresh one so it works all over?

Many thanks in advance.

Daniel