I have a worksheet with checkboxes. When a user selects a checkbox, another sheet is populated with the information relevant to that checkbox. Say for example, in Sheet A there are three checkboxes, one is Apples, one is Organges and the other is Grapefruits. In sheet B is a column with apples in COL A, organes in COL B and bananans In COL C and the differnt places where the fruit can be purchased is listed in each row. A user comes and places a checkmark in apples and bananas, How can I automatically hide the column for bananas for ease of printing?