OK, if you add the following code to the Normal template's 'ThisDocument' module, you should get the desired prompt:
Code:
Option Explicit
Private Sub Document_New()
Call Document_Open
End Sub
Private Sub Document_Open()
If MsgBox("Go to Footer?", vbYesNo, "Destination Selector") = vbYes Then
ActiveWindow.ActivePane.View.SeekView = wdSeekPrimaryFooter
End If
End Sub