First post on this site, so hopefully I'm doing it correctly

I have found this once online but have tried many times since and can't find it anymore.

I record a macro in 2007 to format a chart. When I go to a new worksheet in the same work book and run the macro it will revert back to the original worksheet and reformat the chart again.

How do I make the macro work for what ever chart I am currently selecting?