Updating the date in Custom Header

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to create a header where I can either link the date
to another cell in the worksheet or be able to have the date in the header
always refer to the previous month end. Such as May 31, 2007 for this month.
 
You need to put code in the Workbook_BeforePrint Event:
ActiveSheet.PageSetup.LeftHeader = Format(Range("A1").Value,"Short Date")
for example.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for Dates 5
Format of Header Date 2
Headers and Macros 2
Pivot Table - Group by Date Excel 2007 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Format Header Date 4
Date issues 1
Cell values in custom headers 2

Back
Top