How to display page numbers on the background?

matkwan · September 26, 2009, 10:57pm

Hi,

Is it possible to display the page numbers on the background of the cells?

Please see attachment for what I mean.

Regrards,

Matt

amjad.sahi · September 27, 2009, 1:55am

Hi Matt,

Thank for your inquiry.

Well, it is not the actual background, it is rather a view to notify on how MS Excel displays Page Break Preview for pages in a sheet. When you take the Print Preview of the pages (in the sheet) or do printing this background won’t be rendered/printed.

Thank you.

matkwan · September 27, 2009, 9:27pm

Hi Amjah,

I would like the user to open the excel and see the page numbers, how do I do that in the codes?

Please open the attached test.xls and you see what I mean.

Regards,

Matt

matkwan · September 27, 2009, 9:49pm

Hi Amjah,

Thanks for yr help.

I have found the solution to it from your website documentation:

'Displaying the worksheet in page break preview

worksheet.IsPageBreakPreview = True

MATT