Open View->Header&Footer

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.
 
B

Bob Umlas, Excel MVP

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.
 
Top