Formatting Macro minor changes

[Oppo28]

Hey all, below is my formatting macro that I made (excel 2010), but there are a few things I would like to change:

1. Is it possible to change the date format from '10/24/12' to 'October 24, 2012'? I have '&D' now but not sure if there's a way to format it this other way.
2. I have the macro auto fit all columns on one page, but this shrinks the headers and footers. Is there a way to only shrink the cells, but the headers/footers will stay the same size?

Please Login or Register  to view this content.

Any help would be appreciated, thanks.

[Oppo28]

Ok I got the date header part. Any ideas about the 2nd piece, keeping the headers and footers the same size without shrinking?

[Oppo28]

Got the header/footer thing fixed! Now, is it possible to make the macro move the cursor to 'A1' on each tab as it runs through them? I tried doing this:

Please Login or Register  to view this content.

after the page setup 'With'. This code only seems to move the cursor on the page I'm on when I run the macro, I want it to do it to all.