Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I display the 'Date Modified' in an Excel worksheet header
I have a series of workbooks being shared on a business server and being
updated by a number of sources as new information becomes available. Because the date of these updates is important, I would like the workbook to display the Date Modified in the header of the document when printed. The only way I know to see this date is via Excel's properties window (or in the Details view in Windows). |
#2
|
|||
|
|||
Place this macro in the ThisWorkbook module. The header of the active
worksheet will be the last saved (modified) date: Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim LastDate As String Dim wbProp As String wbProp = "last save time" LastDate = ActiveWorkbook.BuiltinDocumentProperties(wbProp) ActiveSheet.PageSetup.CenterHeader = LastDate End Sub --- HTH Jason Atlanta, GA "DC Solah" wrote: I have a series of workbooks being shared on a business server and being updated by a number of sources as new information becomes available. Because the date of these updates is important, I would like the workbook to display the Date Modified in the header of the document when printed. The only way I know to see this date is via Excel's properties window (or in the Details view in Windows). |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display the 'Date Modified' in an Excel worksheet hea
Will this macro show the last date modified of the worksheet in the workbook?
Is there a way to have each tab display the last modified date for that tab only? "Jason Morin" wrote: Place this macro in the ThisWorkbook module. The header of the active worksheet will be the last saved (modified) date: Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim LastDate As String Dim wbProp As String wbProp = "last save time" LastDate = ActiveWorkbook.BuiltinDocumentProperties(wbProp) ActiveSheet.PageSetup.CenterHeader = LastDate End Sub --- HTH Jason Atlanta, GA "DC Solah" wrote: I have a series of workbooks being shared on a business server and being updated by a number of sources as new information becomes available. Because the date of these updates is important, I would like the workbook to display the Date Modified in the header of the document when printed. The only way I know to see this date is via Excel's properties window (or in the Details view in Windows). |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display the 'Date Modified' in an Excel worksheet hea
how do i know WHO is the last person who modified?
"Jason Morin" wrote: Place this macro in the ThisWorkbook module. The header of the active worksheet will be the last saved (modified) date: Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim LastDate As String Dim wbProp As String wbProp = "last save time" LastDate = ActiveWorkbook.BuiltinDocumentProperties(wbProp) ActiveSheet.PageSetup.CenterHeader = LastDate End Sub --- HTH Jason Atlanta, GA "DC Solah" wrote: I have a series of workbooks being shared on a business server and being updated by a number of sources as new information becomes available. Because the date of these updates is important, I would like the workbook to display the Date Modified in the header of the document when printed. The only way I know to see this date is via Excel's properties window (or in the Details view in Windows). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Date Format - users should be able to override it automatic. | Excel Discussion (Misc queries) | |||
On an import to excel a two digit date still is not right after c. | Excel Discussion (Misc queries) | |||
Excel enters date as a text format | Excel Discussion (Misc queries) | |||
Excel 2003 "File Open": how keep folders at top with sort by Date. | Excel Discussion (Misc queries) | |||
Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) |