Hyperlink buttons don't work out of design mode.

Hi Achtung_boy, welcome to the forum.

Instead of using hyperlinks with command buttons, why not just use a macro behind the command buttons? You just need to go into design mode, right click on each 'Home' button and choose View Code. Add the following one line of code to each:

Sheets("Front page").Activate

Also, your delete macro could be simplified to:

Sub AskAndDo()
If MsgBox("Are you sure ?", vbYesNo + vbQuestion) = vbNo Then
    Exit Sub
Else
    Range("G2:G23,A2:E23").ClearContents
End If
End Sub

Or even

Sub AskAndDo()
If MsgBox("Are you sure ?", vbYesNo + vbQuestion) = vbYes Then Range("G2:G23,A2:E23").ClearContents
End Sub