Active cell switching Sheet

**dekueb** · 03-29-2019, 07:53 AM

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** · 03-29-2019, 09:45 AM

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

Private Sub Worksheet_Activate()
Application.Goto [A1]
End Sub

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

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
    Application.Goto [A1]
End Sub

**dekueb** · 03-30-2019, 02:22 PM

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