hi,
by default, you can only have 1 print area at a time per sheets. but you can
do what you want. just write a print macro which you can do on record. for
each print area you wish, while on record, set the print are, headers and
footer is needed. do this for each area of the sheet that you wish to print.
this way you could assgn each print macro to a button or all macros to the
same button.
Regards
FSt1
"Enzo" wrote:
I need to create a number of print areas in the same sheet within my
spreadsheet. Just to clarify, on sheet1 I need 3 different print areas that I
can access by using the box at the top left, and I also want to be able to
print them directly (via the print icon) as opposed to using
'file-print-selection'
Any ideas?
Thanks,
Enzo
|