Hi
I am trying to make a cover page with a picture filling the whole page. I would like the cover page to:
a) be automatically added as the first page, when printing a worksheet (report), and
b) have title and headlines automatically filled depending on which woorksheet/report I choose for printing.
Regarding a) : The workbook contains several worksheets, in which worksheet 1-5 are reports and the rest are standard information used in the formulars. When printing any sheet between 1-5 the same coverpage should automatically to be added.
Regarding b) : All worksheets (reports) contains the info which are needed on the Cover page. The info are in the same celles on each sheet etc. A1=Title, A2= Name of company and so forth.
I struggle with almost every bit of this task:
- How can I get the picture to fill a whole page with no margins on the print preview?
- How can I set the picture as a background, so I can use cells as the references to what need to be Title, headline and so on? And is this the best procedure?
- Getting it to print the cover page as the first page regardless of the worksheet I want to print.
Br. Thomas
I am trying to make a cover page with a picture filling the whole page. I would like the cover page to:
a) be automatically added as the first page, when printing a worksheet (report), and
b) have title and headlines automatically filled depending on which woorksheet/report I choose for printing.
Regarding a) : The workbook contains several worksheets, in which worksheet 1-5 are reports and the rest are standard information used in the formulars. When printing any sheet between 1-5 the same coverpage should automatically to be added.
Regarding b) : All worksheets (reports) contains the info which are needed on the Cover page. The info are in the same celles on each sheet etc. A1=Title, A2= Name of company and so forth.
I struggle with almost every bit of this task:
- How can I get the picture to fill a whole page with no margins on the print preview?
- How can I set the picture as a background, so I can use cells as the references to what need to be Title, headline and so on? And is this the best procedure?
- Getting it to print the cover page as the first page regardless of the worksheet I want to print.
Br. Thomas