Is there a shorcut key to get to the header footer? I am trying to eventually create a macro that will take me straight to custom header/footer (center page).
Try a macro like this to get to the header and footer view:
Sub HeaderFooter()
Dim cmdBar As CommandBar
Dim cmdBarMenuItem As CommandBarControl
Set cmdBar = Application.CommandBars("View")
Set cmdBarMenuItem = cmdBar.Controls("Header and Footer")
cmdBarMenuItem.Execute
End Sub
Steve
excelman32 said:
Is there a shorcut key to get to the header footer? I am trying to