I have a multi sheet workbook with an on event (sheet activate) macro.

I want to go to a fixed sheet perform a seperate macro and then to return to
the current sheet. Each time a sheet is activated.

Do I need to get the current address in some way and then enter this or is
there a "return here" function?

Many Thanks

Paul Moles