PrintDate "as in MS Word"

[irresistible007]

Very simple question..... Is there is any way to get the same result i
Excel WorkSheet (under Cell) as of PrintDate in "M
Word>Insert>Field>Date and Time>PrintDate" :confused

 

[Andy Brown]

Very simple question..... Is there is any way to get the same result in
Excel WorkSheet (under Cell) as of PrintDate in "MS
Word>Insert>Field>Date and Time>PrintDate"

You could try some code in the ThisWorkbook module, e.g

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Range("A1") = Date
End Sub

For info on event code, see http://www.mvps.org/dmcritchie/excel/event.htm

HTH,
Andy

 

[Jim May]

There is keyboard-shortcut;

With A1 active(and blank) press Control(key)+ ;

HTH


"irresistible007" <[email protected]>
wrote in message
news:[email protected]...