Can you reference cell values in Headers and Footers in Excel 200.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to customize my Header on an Excel spreadsheet to include the value
conatined in certain cells on my worksheet such that I will not have to
change the header every time I change the value of the referenced cell. Does
anyone know how to do this?
 
Hi
only possible with VBA using an event procedure. e.g. put the following
code
in your workbook module for cell A1
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim wkSht As Worksheet
For Each wkSht In Me.Worksheets
With wkSht.PageSetup
.CenterFooter = wksht.range("A1").value
End With
Next wkSht
End Sub
 
Thanks

Frank Kabel said:
Hi
only possible with VBA using an event procedure. e.g. put the following
code
in your workbook module for cell A1
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim wkSht As Worksheet
For Each wkSht In Me.Worksheets
With wkSht.PageSetup
.CenterFooter = wksht.range("A1").value
End With
Next wkSht
End Sub
Click to expand...
 
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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Headers & Footers _auto update info from a cell in the worksheet 4
How do I reference a cell to automatically update in a header 1
Disabling the "&[Time]" or "&[T]" in Excel headers and footers 2
Filename in Excel Cell Address 7
Excel header/footer cell reference 2
Header and Footer 3
How to reference a text cell that changes weekly in Header or Foo. 2

Back
Top