If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating a header/footer with a link to spreadsheet data
I would like to create a footer that displays the version
number of the document. This information is located in the file on a worksheet of its own. I would like to choose a particular cell in that worksheet and have the value appear in the footer. Does anyone know how to make this happen. |
#2
|
|||
|
|||
Creating a header/footer with a link to spreadsheet data
You can use a workbook event that adjusts the header/footer.
Rightclick on the excel icon that is to the left of File (as in File|open) Select view code paste this in your code window: Option Explicit Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim wks As Worksheet For Each wks In Me.Worksheets wks.PageSetup.LeftFooter = "My note from: " _ & Me.Worksheets("sheet99").Range("a1").Value Next wks End Sub It puts the value from A1 in sheet99 in the leftfooter on each sheet right before it prints. wrote: I would like to create a footer that displays the version number of the document. This information is located in the file on a worksheet of its own. I would like to choose a particular cell in that worksheet and have the value appear in the footer. Does anyone know how to make this happen. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Link Tables to Access data queries | Sid | Tables | 3 | June 1st, 2004 09:31 AM |
Copying data to new spreadsheet. | Janet | New Users | 2 | May 19th, 2004 05:58 PM |
copying filtered data to a new spreadsheet | ksweeney | Worksheet Functions | 2 | March 3rd, 2004 03:31 PM |
Outputting Form Data To Excel Spreadsheet | Zara!!!! | Links and Linking | 1 | March 1st, 2004 11:45 PM |
Link to External Data | Bill Manville | Links and Linking | 0 | January 2nd, 2004 08:40 AM |