Identify active worksheet in macro

Hi,

Currently I have 10 tabs in an Excel spreadhsheet - each one is a pivot report. I created one macro to format all 10 reports at one time.. so if anyone filters or drills down on the pivot reports, they can reset the print formatting with this macro.

However, the macro always lands the user back at the first tab.

For example, if someone is on tab 4 and runs the macro, the macro does its
thing and then lands the person on tab 1... not tab 4.

Is there a way to tell in the macro to land back on the worksheet tab the user started on in the first place?

Before executing any of your formatting, try something like:

Please Login or Register  to view this content.

Then, after the procedure is ran, at the end, include:

Please Login or Register  to view this content.

HTH

Jason

Excellent! Works great. Thank you very much.

No problem. Glad to help.