Printing Hidden Sheets, changes sheet view to different sheet

Hello! Can someone review my code and advise me on any changes?

I have a number of visible sheets. On Sheet1 there is a print button.

When I click the print button to initiate the macro to print a hidden sheet (call it Batman1), the sheet prints but the worksheet view automatically tabs over to work Sheet5. I would like for the original sheet, Sheet1 to stay on the screen and not tab over to Sheet5.

Please Login or Register  to view this content.

Originally Posted by rorya

You can store the original sheet and revert to it:

Please Login or Register  to view this content.

I think that solved it! Thanks!!!!!