Hi Everyone,
got a problem here.
I have 35 sheets all of which I need to run the same macro when I exit them.
but when I exit them they are no longer the active sheet so it all goes wrong.
i'm hoping there might be a way to change activesheet to something else and solve this any ideas?
below...