Hi all,
I need help with this one. I'm fairly sure that it's going to require some VBA coding (perhaps in the BeforePrint event?), but am at a loss as to what to speficially code.
I have a "sales proposal" workbook with multiple worksheets for various products which is used by a salesperson to produce a printed proposal.
As a salesperson enters/selects data in these varying worksheets, a "printable" worksheet within this workbook which has been previously formatted to print in 4 pages (basically 1 page for each product and a final Summary/Totals page) is filled in with the appropriate data. When done, the salesperson then selects this "printable" worksheet and prints it.
For instance,
Worksheet A is the software products page.
Worksheet B is the hardware products page.
Worksheet C is the Training/Services page.
Worksheet D is the "printable" page which has been formatted to print in 4 pages.
Here's what I need to do ...
When printing this "printable worksheet", I need it to suppress printing pages for which no product has been selected.
In other words, if a salesperson selected products in the software worksheet only, then when printing the "printable" worksheet, it should only print page 1 and page 4 (which is the software portion and the Totals/Summary portion).
Using the above example, I thought of writing code in the BeforePrint event to hide the rows that comprised pages 2 and 3 in the "printable" worksheet.
However, I then found that there is no AfterPrint event, thus I could not UNHIDE the rows after the printout was done.
Does anyone have any other idea/solution for how to suppress a page from printing?
This message was edited by Rylandir on 2002-08-29 14:45
I need help with this one. I'm fairly sure that it's going to require some VBA coding (perhaps in the BeforePrint event?), but am at a loss as to what to speficially code.
I have a "sales proposal" workbook with multiple worksheets for various products which is used by a salesperson to produce a printed proposal.
As a salesperson enters/selects data in these varying worksheets, a "printable" worksheet within this workbook which has been previously formatted to print in 4 pages (basically 1 page for each product and a final Summary/Totals page) is filled in with the appropriate data. When done, the salesperson then selects this "printable" worksheet and prints it.
For instance,
Worksheet A is the software products page.
Worksheet B is the hardware products page.
Worksheet C is the Training/Services page.
Worksheet D is the "printable" page which has been formatted to print in 4 pages.
Here's what I need to do ...
When printing this "printable worksheet", I need it to suppress printing pages for which no product has been selected.
In other words, if a salesperson selected products in the software worksheet only, then when printing the "printable" worksheet, it should only print page 1 and page 4 (which is the software portion and the Totals/Summary portion).
Using the above example, I thought of writing code in the BeforePrint event to hide the rows that comprised pages 2 and 3 in the "printable" worksheet.
However, I then found that there is no AfterPrint event, thus I could not UNHIDE the rows after the printout was done.
Does anyone have any other idea/solution for how to suppress a page from printing?
This message was edited by Rylandir on 2002-08-29 14:45