Print Sheet Name in the Header with Macro

Hi Experts

Just wondering what property is require to print sheet name in the header NOT workbook name.

I am trying the following code and getting an error message.

Please Login or Register  to view this content.

One more query I have is to set my print page order to Over, Then Down where as the default order is Down, Then Over.
Any suggestions?


Thanks
Raj

Try this:

Please Login or Register  to view this content.

Thanks Mate