Hi there,

I've set up a macro that converts my workbook to PDF and emails it off to certain users instead of the old method of printing out the pages on different coloured paper depending on the page.

This is the routine I run (after creating the array of sheets to be printed):

Sheets(arSheets).Select

pdfName = Worksheets("Distbn List").Range("Month").Text & " - " & Worksheets("Distbn List").Cells(coli, 1).Value
FolderName = Worksheets("Distbn List").Range("Location").Text
FullName = FolderName & pdfName & ".pdf"

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=FullName _
, IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:=False


Is there a routine I can run either before this that changes the background of the page to a certain colour (either green, blue or white) all the way to the page edge of the page?

I've obviously tried the quick and easy route of "format cells / fill" but that only fills the active cells to the edge of the page margin and leaves a white border around the page, which has been turned down as a solution by management.

Changing the page margin in setup to 0 doesn't do the job entirely either, again there is a white border left.

Many thanks in advance,

Mike