custom views
Sounds like your macro hard codes the date to 2005.
You will have to edit this macro.
Is it an event macro in a sheet or a Thisworbook macro or a General macro?
When you find out which, let us know so's we can help you edit the code.
Or send me the workbook via email and I'll have a look.
Change the AT and DOT to appropriate punctuation.
Gord Dibben MS Excel MVP
On Thu, 5 Oct 2006 09:20:01 -0700, mac wrote:
I have a excel workbook. It has custom views one is name compliance
6/30/2005.
When I select button it prints okay but the date printed is 6/30/2005. I
want to change the date to 6/30/2006. Can you help with this. I know there
is a macro but I did not set it up and do not want to mess it up. I tried
to change the header and if I do and print the individual sheet it is okay,
but when I start the macro it comes out with the previous year. Any ideas.
/--
thank you mac
|