Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SaveData Field
Is it possible to insert a SaveDate field in an Excel worksheet footer?
-- PCGrammy |
#2
|
|||
|
|||
Not really. The best you can do is to use a VBA procedure to
enter the property value. In the ThisWorkbook code module, use code like the following: Private Sub Workbook_BeforePrint(Cancel As Boolean) Me.Worksheets("Sheet1").PageSetup.CenterFooter = _ Me.BuiltinDocumentProperties("Last Save Time").Value End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "PCGrammy" wrote in message ... Is it possible to insert a SaveDate field in an Excel worksheet footer? -- PCGrammy |
#3
|
|||
|
|||
Note: If you use Excel 97 this Property will not update
See http://www.rondebruin.nl/print.htm#Saved -- Regards Ron de Bruin http://www.rondebruin.nl "Chip Pearson" wrote in message ... Not really. The best you can do is to use a VBA procedure to enter the property value. In the ThisWorkbook code module, use code like the following: Private Sub Workbook_BeforePrint(Cancel As Boolean) Me.Worksheets("Sheet1").PageSetup.CenterFooter = _ Me.BuiltinDocumentProperties("Last Save Time").Value End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "PCGrammy" wrote in message ... Is it possible to insert a SaveDate field in an Excel worksheet footer? -- PCGrammy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Comment Field | Excel Discussion (Misc queries) | |||
Pivot table field types | Excel Discussion (Misc queries) | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) |