Open View->Header&Footer

  • Thread starter Thread starter Sanjay Rao
  • Start date Start date
S

Sanjay Rao

Is it possible that on opening Excel , View -> Header &
Footer opens automatically.

The reason is that I need all the users to add a footer
for all the documents. Hence the requirement is that this
box opens on default or some other way where in they can
be prompted to change the footer.
 
Private Sub Workbook_Open()
Application.SendKeys "%vh"
End Sub
The above works if you place that code in the Thisworkbook code: right-click
the excel LOGO near the file menu and paste the code there.
 
Back
Top