Hiding Controls when printing an Excel Spreadsheet
Posted by Clinton Hayes on August 14, 2001 7:55 PM
I have created a quotation form in Excel utilising various controls to select product and price groups for a quotation. Allowing other users to simply select the category and have the quotation priced correctly was the aim.
However, as I've added controls to each line, when the quotation is finished and printed, all the unused lines show the controls. Al I really want the form to show is the information from the control and if none entered, then show nothing.
Would appreciate any help.