Written by Allen Wyatt (last updated October 8, 2022)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, 2021, and Excel in Microsoft 365
When you are putting together a workbook, Excel tracks quite a bit of information that it collectively refers to as workbook properties. You can view the different properties maintained by displaying the Properties dialog box.
In Word you have the option to print document properties, if you desire. There is no intrinsic way to print workbook properties in Excel. Instead, you must resort to a macro that will place the names and values of the properties into a worksheet. You can then print the worksheet and have your workbook properties available in hardcopy format.
The following macro is an example of a good way to copy all the workbook properties to a worksheet that can be printed:
Public Sub WorkbookProperties() Dim p As DocumentProperty Dim iRow As Integer 'Add new worksheet for info Worksheets.Add 'Built in Properties iRow = 1 Cells(iRow, 1).Value = "Built-in Properties" Cells(iRow, 1).Font.Bold = True iRow = iRow + 1 Worksheets(1).Activate For Each p In ActiveWorkbook.BuiltinDocumentProperties On Error Resume Next Cells(iRow, 2).Value = p.Name 'If no value then Excel causes an error so ignore! Cells(iRow, 3).Value = p.Value iRow = iRow + 1 Next On Error GoTo 0 'Custom Properties iRow = iRow + 1 Cells(iRow, 1).Value = "Custom Properties" Cells(iRow, 1).Font.Bold = True iRow = iRow + 1 For Each p In ActiveWorkbook.CustomDocumentProperties On Error Resume Next Cells(iRow, 2).Value = p.Name Cells(iRow, 3).Value = p.Value iRow = iRow + 1 Next On Error GoTo 0 End Sub
Note:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (9149) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, 2021, and Excel in Microsoft 365. You can find a version of this tip for the older menu interface of Excel here: Printing Workbook Properties.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
Want to limit who can use your workbook and on what system? Locking down a workbook can be trickier than you might imagine.
Discover MoreHaving trouble saving a workbook? It could have to do with the age, size, and complexity of that workbook. This tip ...
Discover MoreIf you are using Excel as a repository for data used in your business, you may want to figure out a way to make that ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2023-10-03 15:27:19
J. Woolley
My comment below describes the ListDocProperties function. My Excel Toolbox also includes the following functions to set or return the value of a workbook's built-in or custom document property:
=SetDocProperty(Name, Value, [AsDate], [Delete])
=GetDocProperty(Name, [Approx])
For details, see my recent comment here: https://excelribbon.tips.net/T012333
2022-10-12 10:10:57
J. Woolley
My Excel Toolbox includes the following dynamic array function to list both built-in and custom (if any) document properties for the formula cell's workbook:
=ListDocProperties([SkipNull],[SkipCustom],[SkipHeader])
The following function will list all of a workbook's current properties, which are not the same as its document properties:
=ListWBProperties([SkipIgnored],[SkipHeader])
In older versions of Excel you can use these functions with the SpillArray function like this:
=SpillArray(List...(...))
See https://sites.google.com/view/MyExcelToolbox/
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments