Is it possible to print the document properties in Excel?
I have an excel workbook that is on a sharepoint site with custom document
properties. Can I print these properties when I print the workbook? |
Is it possible to print the document properties in Excel?
To get a list of all Custom Properties run the following macro.
Sub customprops() rw = 1 Worksheets.Add For Each p In ActiveWorkbook.CustomDocumentProperties Cells(rw, 1).Value = p.Name Cells(rw, 3).Value = p.Value rw = rw + 1 Next End Sub Gord Dibben MS Excel MVP On Thu, 26 Feb 2009 06:07:01 -0800, pcastillo wrote: I have an excel workbook that is on a sharepoint site with custom document properties. Can I print these properties when I print the workbook? |
All times are GMT +1. The time now is 01:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com