Currently I have 10 pivot reports in one Excel spreadsheet. I built in one
macro to go through and format all 10 reports for printing at one time ...
with the first tab report being the last report that's formatted. The
problem is that if someone is on tab 4 and runs the macro, the macro does its
thing by formatting all reports however the person ends back up in tab 1
report. This will occur on all tabs.

Is there a way to tell in the macro which sheet the user ran the macro from
and take them right back to that same sheet?

Thanks, Mary-Lou