View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default 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