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
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