Hi there, thanks in advance for your help.
I have little experience with VBA. I have a workbook with worksheet and workbook protection and multiple sheets. I want to have a button on one of the sheets, that when clicked, will proceed to: 1. hide/unhide rows/columns in other sheets based on true/false cell values in the other sheets, and then print the some specific sheets (say sheet 5 to 10) if a cell value in each of the sheets = true i.e if false, do not print the sheet. Please help!
I've attached a sample. Cheers!
I have little experience with VBA. I have a workbook with worksheet and workbook protection and multiple sheets. I want to have a button on one of the sheets, that when clicked, will proceed to: 1. hide/unhide rows/columns in other sheets based on true/false cell values in the other sheets, and then print the some specific sheets (say sheet 5 to 10) if a cell value in each of the sheets = true i.e if false, do not print the sheet. Please help!
I've attached a sample. Cheers!