Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
properties in header
Is there a way to include file properties in a custom header?
For example, I've defined a custom file property, "Property Name", would like the user to enter that value when opening the workbook, and have whatever is entered displayed in the heading when printing. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
properties in header
This does not answer your specifics, but for Builtin properties:
Private Sub Workbook_BeforePrint(Cancel As Boolean) s = ActiveWorkbook.BuiltinDocumentProperties("author") ActiveSheet.PageSetup.CenterHeader = s End Sub in ThisWorkbook code, not a standard module. Can be adapted for Custom. -- Gary's Student "IMFletch" wrote: Is there a way to include file properties in a custom header? For example, I've defined a custom file property, "Property Name", would like the user to enter that value when opening the workbook, and have whatever is entered displayed in the heading when printing. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort does not recognize the header row | New Users to Excel | |||
Can XLS automatically insert file properties fields into a header | Excel Worksheet Functions | |||
How can I using Excel custom document properties in the header? | Excel Worksheet Functions | |||
Document Properties in Header or Footer | Excel Discussion (Misc queries) | |||
Printing the page properties as header | Excel Discussion (Misc queries) |