Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Printing / January 2005

Tip: Looking for answers? Try searching our database.

&[Time}\]

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Robert Wilcox - 10 Jan 2005 04:24 GMT
How do I display hh:mm:ss in a footer?  Currently
&[time] displays hh:mm
Gord Dibben - 10 Jan 2005 18:45 GMT
Robert

I have not been able to change that default.  Perhaps someone else will jump
in.

A macro can be used.

Sub PathInFooter()
   ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.FullName & " " & _
      ActiveSheet.Name & " " & Application.UserName & _
      " " & Format(Now(), "h:mm:ss AM/PM")
End Sub

To just enter the time in the footer.......

Sub TimeFooter()
ActiveSheet.PageSetup.RightFooter = Format(Now(), "h:mm:ss AM/PM")
End Sub

Gord Dibben Excel MVP

>How do I display hh:mm:ss in a footer?  Currently
>&[time] displays hh:mm
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.