Revise Existing Excel COP Document

Change order/extra project associated with Excel COP Template Creation: 1) I want the PM’s to send a copy of the CO Log along with the COP’s to their customers. I made a clunky macro on the COP template that only prints applicable pages and such for the customer. Add code to the existing macro on the COP Template (I’ll send you a clean master version) that will run your ‘Update CO’ code and include a copy of the log with the print job for the given project. 2) On the 'Cover' sheet, I have a toggle box for 'Show Material' that is supposed show the material selected ont he 'Material Data' page. It works, but the user has to toggle the checkbox to refresh the list. I tride setting the macro to run when the sheet is activated, but it only needs to be updated when the checkbox is checked. Clean the code so the user won't have to toggle to refresh. 3) I'd like your 'Old' check box to follow the same formatting as the 'Show Material' checkbox 4) Lastly, our Control Air icons are really inconsistent from worksheet to worksheet.