software

Hi!
Is is possible to have a customized format of Date (say, DD MM YY) for
Header/ Footer in Excel

Thanx
--
Dr. Sachin Wagh
MBBS, DHA, DPH

with vba

ActiveSheet.PageSetup.LeftHeader = Format(Date, quot;dd mm yyquot;)--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Dr. Sachin Waghquot; gt; wrote in message
...
gt; Hi!
gt; Is is possible to have a customized format of Date (say, DD MM YY) for
gt; Header/ Footer in Excel
gt;
gt; Thanx
gt; --
gt; Dr. Sachin Wagh
gt; MBBS, DHA, DPH
highlight header/footer
format cells custom
and type in reference
dd mm yy
click ok
==============
quot;Dr. Sachin Waghquot; gt; wrote in message
...
gt; Hi!
gt; Is is possible to have a customized format of Date (say, DD MM YY) for
gt; Header/ Footer in Excel
gt;
gt; Thanx
gt; --
gt; Dr. Sachin Wagh
gt; MBBS, DHA, DPH
Thanx Venkataraman
Could you please elaborate on this 'highlight Header/ Footer'
My purpose is to have 'system date' automatically updated in the header
(with the said format)

Regards
--
Dr. Sachin Wagh
MBBS, DHA, DPHquot;R.VENKATARAMANquot; wrote:

gt; highlight header/footer
gt; format cells custom
gt; and type in reference
gt; dd mm yy
gt; click ok
gt; ==============
gt; quot;Dr. Sachin Waghquot; gt; wrote in message
gt; ...
gt; gt; Hi!
gt; gt; Is is possible to have a customized format of Date (say, DD MM YY) for
gt; gt; Header/ Footer in Excel
gt; gt;
gt; gt; Thanx
gt; gt; --
gt; gt; Dr. Sachin Wagh
gt; gt; MBBS, DHA, DPH
gt;
gt;
gt;

Filegt;page setupgt;header/footer or viewgt;header and footer, select custom,
select the date icon

--
Regards,

Peo Sjoblom

(No private emails please)quot;Dr. Sachin Waghquot; gt; wrote in message
...
gt; Thanx Venkataraman
gt; Could you please elaborate on this 'highlight Header/ Footer'
gt; My purpose is to have 'system date' automatically updated in the header
gt; (with the said format)
gt;
gt; Regards
gt; --
gt; Dr. Sachin Wagh
gt; MBBS, DHA, DPH
gt;
gt;
gt; quot;R.VENKATARAMANquot; wrote:
gt;
gt;gt; highlight header/footer
gt;gt; format cells custom
gt;gt; and type in reference
gt;gt; dd mm yy
gt;gt; click ok
gt;gt; ==============
gt;gt; quot;Dr. Sachin Waghquot; gt; wrote in
gt;gt; message
gt;gt; ...
gt;gt; gt; Hi!
gt;gt; gt; Is is possible to have a customized format of Date (say, DD MM YY) for
gt;gt; gt; Header/ Footer in Excel
gt;gt; gt;
gt;gt; gt; Thanx
gt;gt; gt; --
gt;gt; gt; Dr. Sachin Wagh
gt;gt; gt; MBBS, DHA, DPH
gt;gt;
gt;gt;
gt;gt;Probably the question is not understood properly. I need the System Date in
the header in DD MM YY format, which should be updated automatically
--
Dr. Sachin Wagh
MBBS, DHA, DPHquot;Peo Sjoblomquot; wrote:

gt; Filegt;page setupgt;header/footer or viewgt;header and footer, select custom,
gt; select the date icon
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; (No private emails please)
gt;
gt;
gt; quot;Dr. Sachin Waghquot; gt; wrote in message
gt; ...
gt; gt; Thanx Venkataraman
gt; gt; Could you please elaborate on this 'highlight Header/ Footer'
gt; gt; My purpose is to have 'system date' automatically updated in the header
gt; gt; (with the said format)
gt; gt;
gt; gt; Regards
gt; gt; --
gt; gt; Dr. Sachin Wagh
gt; gt; MBBS, DHA, DPH
gt; gt;
gt; gt;
gt; gt; quot;R.VENKATARAMANquot; wrote:
gt; gt;
gt; gt;gt; highlight header/footer
gt; gt;gt; format cells custom
gt; gt;gt; and type in reference
gt; gt;gt; dd mm yy
gt; gt;gt; click ok
gt; gt;gt; ==============
gt; gt;gt; quot;Dr. Sachin Waghquot; gt; wrote in
gt; gt;gt; message
gt; gt;gt; ...
gt; gt;gt; gt; Hi!
gt; gt;gt; gt; Is is possible to have a customized format of Date (say, DD MM YY) for
gt; gt;gt; gt; Header/ Footer in Excel
gt; gt;gt; gt;
gt; gt;gt; gt; Thanx
gt; gt;gt; gt; --
gt; gt;gt; gt; Dr. Sachin Wagh
gt; gt;gt; gt; MBBS, DHA, DPH
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;

Not understood because it was not stated as such.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftHeader = Format(Date, quot;dd mm yyquot;)
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code
--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Dr. Sachin Waghquot; gt; wrote in message
...
gt; Probably the question is not understood properly. I need the System Date
in
gt; the header in DD MM YY format, which should be updated automatically
gt; --
gt; Dr. Sachin Wagh
gt; MBBS, DHA, DPH
gt;
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt; gt; Filegt;page setupgt;header/footer or viewgt;header and footer, select custom,
gt; gt; select the date icon
gt; gt;
gt; gt; --
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; (No private emails please)
gt; gt;
gt; gt;
gt; gt; quot;Dr. Sachin Waghquot; gt; wrote in
message
gt; gt; ...
gt; gt; gt; Thanx Venkataraman
gt; gt; gt; Could you please elaborate on this 'highlight Header/ Footer'
gt; gt; gt; My purpose is to have 'system date' automatically updated in the
header
gt; gt; gt; (with the said format)
gt; gt; gt;
gt; gt; gt; Regards
gt; gt; gt; --
gt; gt; gt; Dr. Sachin Wagh
gt; gt; gt; MBBS, DHA, DPH
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;R.VENKATARAMANquot; wrote:
gt; gt; gt;
gt; gt; gt;gt; highlight header/footer
gt; gt; gt;gt; format cells custom
gt; gt; gt;gt; and type in reference
gt; gt; gt;gt; dd mm yy
gt; gt; gt;gt; click ok
gt; gt; gt;gt; ==============
gt; gt; gt;gt; quot;Dr. Sachin Waghquot; gt; wrote in
gt; gt; gt;gt; message
gt; gt; gt;gt; ...
gt; gt; gt;gt; gt; Hi!
gt; gt; gt;gt; gt; Is is possible to have a customized format of Date (say, DD MM YY)
for
gt; gt; gt;gt; gt; Header/ Footer in Excel
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; Thanx
gt; gt; gt;gt; gt; --
gt; gt; gt;gt; gt; Dr. Sachin Wagh
gt; gt; gt;gt; gt; MBBS, DHA, DPH
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt;
gt; gt;
Thanx a ton Bob!
I was responding to Venkataraman in my earlier reply

Your suggestion did the trick!

--
Dr. Sachin Wagh
MBBS, DHA, DPHquot;Bob Phillipsquot; wrote:

gt; Not understood because it was not stated as such.
gt;
gt; Private Sub Workbook_BeforePrint(Cancel As Boolean)
gt; ActiveSheet.PageSetup.LeftHeader = Format(Date, quot;dd mm yyquot;)
gt; End Sub
gt;
gt; 'This is workbook event code.
gt; 'To input this code, right click on the Excel icon on the worksheet
gt; '(or next to the File menu if you maximise your workbooks),
gt; 'select View Code from the menu, and paste the code
gt;
gt;
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Dr. Sachin Waghquot; gt; wrote in message
gt; ...
gt; gt; Probably the question is not understood properly. I need the System Date
gt; in
gt; gt; the header in DD MM YY format, which should be updated automatically
gt; gt; --
gt; gt; Dr. Sachin Wagh
gt; gt; MBBS, DHA, DPH
gt; gt;
gt; gt;
gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt;
gt; gt; gt; Filegt;page setupgt;header/footer or viewgt;header and footer, select custom,
gt; gt; gt; select the date icon
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Regards,
gt; gt; gt;
gt; gt; gt; Peo Sjoblom
gt; gt; gt;
gt; gt; gt; (No private emails please)
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Dr. Sachin Waghquot; gt; wrote in
gt; message
gt; gt; gt; ...
gt; gt; gt; gt; Thanx Venkataraman
gt; gt; gt; gt; Could you please elaborate on this 'highlight Header/ Footer'
gt; gt; gt; gt; My purpose is to have 'system date' automatically updated in the
gt; header
gt; gt; gt; gt; (with the said format)
gt; gt; gt; gt;
gt; gt; gt; gt; Regards
gt; gt; gt; gt; --
gt; gt; gt; gt; Dr. Sachin Wagh
gt; gt; gt; gt; MBBS, DHA, DPH
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;R.VENKATARAMANquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt;gt; highlight header/footer
gt; gt; gt; gt;gt; format cells custom
gt; gt; gt; gt;gt; and type in reference
gt; gt; gt; gt;gt; dd mm yy
gt; gt; gt; gt;gt; click ok
gt; gt; gt; gt;gt; ==============
gt; gt; gt; gt;gt; quot;Dr. Sachin Waghquot; gt; wrote in
gt; gt; gt; gt;gt; message
gt; gt; gt; gt;gt; ...
gt; gt; gt; gt;gt; gt; Hi!
gt; gt; gt; gt;gt; gt; Is is possible to have a customized format of Date (say, DD MM YY)
gt; for
gt; gt; gt; gt;gt; gt; Header/ Footer in Excel
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt; Thanx
gt; gt; gt; gt;gt; gt; --
gt; gt; gt; gt;gt; gt; Dr. Sachin Wagh
gt; gt; gt; gt;gt; gt; MBBS, DHA, DPH
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;