Shorcut key for header header footer

G

Guest

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).
 
S

Steve Yandl

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
eventually create a macro that will take me straight to custom header/footer
(center page).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top