Hi, I am writing a VB program that needs to watermark pages in a spreadsheet, at run time nothing will be known about the spreadhsheet, ie how many worksheets, how many pages per worksheet etc. If I can direct users to ensure there spreadsheets are in a printable format , you know, resized page magins set and all the rest can anyone point me to some VBA code that will paint a watermark on each page? cheers.