Run Macro when click on different tab in Excel
Is there a way to set up a macro to run when you click on a different tab in
the Excel sheet? I have a data tab where I pull my data tab that I have set
up a macro to format some of the data in that pull. Would like that macro to
run when I click on the pivot tab. Is this possible?
|