Date in Header

[eggtimer]

Hi

Is it possible to create a setting somewhere that on every new spreadsheet I create, the date automatically appears in the top right header window when printing? (Getting a little bit of grief for not dating reports)

On most of my continuing reports I have a "=today()" somewhere.

But the problem I am getting is where I just pull some data, drop it on a sheet and run a quick pivot table. I always title it, rarely date it.

I am thinking of putting it in the Header, because I don't print a lot of my spreadsheets, and cannot think of a consistently spare cell in all sheets.

Or is there some sort of OnPrint type event I can have run each time, I print, I have a workbook that opens from XLstart is it possible to put anything in there?


Thanks


Wayne

 

[Andrew Poulsom]

Create a workbook template with the header set up the way you want:

http://office.microsoft.com/en-us/excel/HP051995961033.aspx

 

[eggtimer]

Thank you

I will do that this afternoon


Wayne

 

[VoG]

Or right click the Excel logo just to the left of File on the menu bar, select View Code and paste in

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.CenterHeader = "&D"
End Sub

 

[eggtimer]

Cheers

I like that sound of that as well

I have 2007, so don't have "File" anymore, do you know where to put it in 2007?


Wayne

 

[VoG]

In Excel 2007 press ALT + F11 to open the Visual Basic Editor, in the left hand pane under 'Project - VBAProject' Right click ThisWorkbook and select View Code.

 

[eggtimer]

Hi, i tried that, could only find "This Workbook" under the actual workbook I was in.

Should there be a "This workbook" that controls all future workbooks i create?

Wayne

 

[VoG]

Sorry, my code will only work in the current workbook. If you want something that applies to all workbooks then Andrew's suggestion of a template is a much better idea.

 

[eggtimer]

Cool, no worries

Thought i was missing something there

Maybe a good idea for the future.

I haven't looked into it, but i preferred your idea, because i have the "New Document" item on Quick Access toolbar.

I am hoping that I can set the template as the default and it will be triggered by this icon, or if not I can associate another icon with this template.

If that is the case, no need to reply, I'm just being lazy.

Thanks guy's


Wayne