Active cell switching Sheet

[dekueb]

Hello everyone,

I'm just wondering if there is a way to force Excel when exit/changeing the active sheet to go back to a specific cell.

Please see exemple

[dotchiejack]

Yes there is.
With a little macro in the sheet code. (right click on sheet name)
for sheet 1

Please Login or Register  to view this content.

If it is the same for all sheets.
In the ThisWorkbook module

Please Login or Register  to view this content.

[dekueb]

Hi dotchiejack,
Thanks for your reply, but not really what I need.
Your code breaks my hyperlinks I have in the workbook, but maybe I was not clear enough with my request, so please find another file