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

Guest

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.
 

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

Similar Threads

Change Header & Footer Info w/ Worksheet Option Buttons 1
Header/Footer to update on all sheets 5
Header/footer 2
Entering same header & or footer into several worksheets 2
Copy of Header-Footer in Excel 3
header and footer view 1
Viewing header/footer in Excel very slow 1
Static Date in Header/Footer 3

Top