Falls der User das Dokument abspeichert, soll Excel autoamtsich in Sheet1 springen und dann noch mal abspeichern.
Wie mache ich das?
MFG Sven
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets(1).[A1].Activate
End Sub
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Application.Goto Sheets("Tabelle1").Range("A1")
End Sub