Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How about this macro:
Sub Macro1() With ActiveSheet.PageSetup .PrintTitleRows = "" .PrintTitleColumns = "" End With ActiveSheet.PageSetup.PrintArea = "" With ActiveSheet.PageSetup .CenterHeader = "" .LeftHeader = "" i = 1 For Each wp In ActiveWorkbook.BuiltinDocumentProperties If i = 12 Or i = 11 Then On Error Resume Next .CenterHeader = .CenterHeader & wp.Name & " " & wp.Value & Chr(10) End If i = i + 1 Next End With End Sub -- Gary''s Student - gsnu200800 "Andy Holm" wrote: I would like to print Excel file properties like it is possible to do for Word documents to show date created, saved, etc. Is there a way to do this? Thanks for the help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I print file properties with worksheet in excel ? | Excel Discussion (Misc queries) | |||
is it possible to print file properties in excel? | Excel Discussion (Misc queries) | |||
How do I print the Excel File Properties Contents screen? | Excel Discussion (Misc queries) | |||
How can you print file properties in an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Unusual "Properties" information | Excel Discussion (Misc queries) |