print multiple sheets override print event

I have a spreadsheet with multiple tabs. I would like to be able to select various tabs for printing page 1. For one specific tab I would like to filter a table, then print pages 1 & 3. I have written a macro, put it inside a workbook _BeforePrint event which runs the macro, but it prints the tab twice. Once from the print event and once by calling the macro.
Is there a way of overwriting the print event for this specific tab when it's printed? or is there a better solution to this problem?
Thanks in advance,
Tim

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Unfortunately that still prints page 1 twice.

Yes, this stops printing page 1 twice, thanks. The problem is when I select 11 tabs the print cancels after a couple of sheets. I'm assuming this cancels the print event? Can I add a conditional statement which runs the statement based on whether the sheet is active (or has been selected to print)?

Solved! This was my final code if it helps.

Please Login or Register  to view this content.