Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up a Custom Header that references a specific cell
When printing in excel, I need to create a custom header that will reference
a specific cell on a specific sheet. In this case it would contain a date (different from today's date) to be printed on the spreadsheet. specifically " production ending "wk1:a1"" so that it would then print: production ending 6/5/06 thanks Norm |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up a Custom Header that references a specific cell
Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet.PageSetup .LeftHeader = "production ending " & _ Format(Worksheets("wk1").Range("A1").Value, "m/d/yy") End With End Sub This is workbook event code. To input this code, right click on the Excel icon on the worksheet (or next to the File menu if you maximise your workbooks), select View Code from the menu, and paste the code -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Norm" wrote in message ... When printing in excel, I need to create a custom header that will reference a specific cell on a specific sheet. In this case it would contain a date (different from today's date) to be printed on the spreadsheet. specifically " production ending "wk1:a1"" so that it would then print: production ending 6/5/06 thanks Norm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell content in custom header: How? | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions |