Sam
First off.........save a backup of your workbook.
Then use this User Defined Function
Function DocProps(prop As String)
Application.Volatile
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties _
(prop)
Exit Function
err_value:
DocProps = CVErr(xlErrValue)
End Function
'=DOCPROPS("last author")
'or
'=DOCPROPS("last save time")
'or
'DOCPROPS("creation date")
'or
'=DocProps("last print date")
For a list of other properties that may be available(not all are), run this
macro.
Sub props()
rw = 1
Worksheets.Add
For Each p In ActiveWorkbook.BuiltinDocumentProperties
Cells(rw, 1).Value = p.Name
rw = rw + 1
Next
End Sub
If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started".
http://www.mvps.org/dmcritchie/excel/getstarted.htm
In the meantime..........
To create a General Module, hit ALT + F11 to open the Visual Basic Editor.
Hit CRTL + R to open Project Explorer.
Find your workbook/project and select it.
Right-click and Insert>Module. Paste the above code in there. Save the
workbook and hit ALT + Q to return to Excel window.
Enter the formula in any cell as shown above.
Gord Dibben Excel MVP
On Sat, 30 Sep 2006 07:44:02 -0700, Sam <Sam[ at ]discussions.microsoft.com> wrote:
[Quoted Text] >I have a timesheet spreadsheet with worksheets for each day. I want the date
>that a specific worksheet (e.g., Tuesday) is printed and don't want that date
>to change on the worksheet until/unless that specific worksheet is printed
>again. Each worksheet could/should have a different print date. Using
>header/footer shows the date it is printed, but changes each day. Is there a
>way to do this?
Gord Dibben MS Excel MVP
|