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 Excel by simply choosing the Properties option from the File menu.
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 VBA macro is an example of a good way to copy all the workbook properties to a worksheet that can be printed:
Public Sub WorksheetProperties() Dim p As DocumentProperty Dim iRow As Integer '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 (2491) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Printing Workbook Properties.
Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!
Excel allows you to specify certain rows or columns that will be repeated on the pages of a printout. Here's how to set ...
Discover MoreNeed to have your print settings always be a certain way? Tired of resetting the settings after others use the workbook ...
Discover MoreWant a list of all the worksheets in your workbook? Here's a short, handy macro that will place all the worksheet names ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2014-07-31 02:08:26
Can I get instead macro an add inn application for excel 2013 pro 64 bit?
With best regard
Bercu Leon
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2021 Sharon Parq Associates, Inc.
Comments