ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Adding and Removing Extra Pages (https://www.excelbanter.com/excel-discussion-misc-queries/174119-adding-removing-extra-pages.html)

Marcus Feldmore

Adding and Removing Extra Pages
 
I have a quote template setup for our companies use on the field. This allows
our sales team to have a standard quoting system for our products. What I
need to do is provide the user the option with a check box click to include
or exclude a notes section.
if the user Selects NO the printed quote will not have the extra blank page
attached. If the user selects Yes another page is shown where the user can
enter notes and print.

Please let me know how this can be achieved.

Thanks

Marcus

ShaneDevenshire

Adding and Removing Extra Pages
 
Hi,

Try attaching code to the check box which sets the Print Area.

--
Cheers,
Shane Devenshire


"Marcus Feldmore" wrote:

I have a quote template setup for our companies use on the field. This allows
our sales team to have a standard quoting system for our products. What I
need to do is provide the user the option with a check box click to include
or exclude a notes section.
if the user Selects NO the printed quote will not have the extra blank page
attached. If the user selects Yes another page is shown where the user can
enter notes and print.

Please let me know how this can be achieved.

Thanks

Marcus



All times are GMT +1. The time now is 11:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com