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.
 
You must log in or register to reply here.

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

Viewing header/footer in Excel very slow 1
Change Header & Footer Info w/ Worksheet Option Buttons 1
Excel 2007, Headers & Footers question 2
Header/Footer to update on all sheets 5
Headers & Footers _auto update info from a cell in the worksheet 4
Copy of Header-Footer in Excel 3
Disabling the "&[Time]" or "&[T]" in Excel headers and footers 2
Excel 2007 Header Doesn't Print 1

Back
Top