Macro to setup page is not working correclty

[Larry.LeBlanc@O]

I recorded a macro to setup the page for printing with the:
file name as the center header
sheet name as the right header
row and column headings printed (the column letters and the row numbers)
gridlines shown
orientation landscape.
The code does not work correctly when I re-run it. It produces “&R” as the center header and DOES NOT print the comments in place. Oddly, when I delete the following lines, it does work:
Application.PrintCommunication = False
Application.PrintCommunication = True

Any ideas why? The recorded code (after removing extraneous lines) is below.
Thank you.

Please Login or Register  to view this content.

[TMS]

What version of Excel are you using. Application.PrintCommunication is new in Excel 2010. No idea what it would do in any other version.

Regards, TMS

[Larry.LeBlanc@O]

I am using Excel 2010. The code I provided is an excerpt from recorded code. (The entire recorded code does not work, either)

[simchuck]

I can't answer your question, only share in the frustration. However I did come across the below post which provides some additional background. I have personally experienced all of the 'symptoms' mentioned...

http://www.edugeek.net/blogs/pico/75...mmunicate.html