PrintDate "as in MS Word"
 

Very simple question..... Is there is any way to get the same result in
Excel WorkSheet (under Cell) as of PrintDate in "MS
WordInsertFieldDate and TimePrintDate" :confused:


--
irresistible007


------------------------------------------------------------------------
irresistible007's Profile: http://www.hightechtalks.com/m63
View this thread: http://www.hightechtalks.com/t2258897

irresistible007 wrote:
Very simple question..... Is there is any way to get the same result in
Excel WorkSheet (under Cell) as of PrintDate in "MS
WordInsertFieldDate and TimePrintDate" :confused:


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

There is keyboard-shortcut;

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

HTH


"irresistible007"
wrote in message
...

Very simple question..... Is there is any way to get the same result in
Excel WorkSheet (under Cell) as of PrintDate in "MS
WordInsertFieldDate and TimePrintDate" :confused:


--
irresistible007


------------------------------------------------------------------------
irresistible007's Profile: http://www.hightechtalks.com/m63
View this thread: http://www.hightechtalks.com/t2258897