
Macro To Hide Multiple Sheets Based On Cell Value, This macro .
Macro To Hide Multiple Sheets Based On Cell Value, You can get a lot of that code Hi everyone, I am back as I am unsure how to write this macro. This macro Hi,I am creating a survey form which requires respondent to fill the number of feedback to be given (e. Typically, in the VBA code, you would unprotect the range, do the hiding/unhiding, then re-protect the range. All you need to do is click Yes to hide the sheet and No I've got an excel sheet with 5 sheets, sheet 1 acting as the main sheet. The range is from A8:A556. I want to be able to click on the Tab List 1 Button, and it to makes just Sheet1:Sheet5 visible, and hiding all other sheets. Here is what I have: What I basically want to do is use a OR condition to show a hidden worksheett based on those values stored in multiple cells. Learn them, download the workbook, and practice. Assuming that all I would like to get a macro that: - Hides several sheets - Hide sheets based on value in cell E:226 each sheet, IF cell value is 0 then hide 1. For example, Not all questions have to be answered, and I'm trying to make a macro that would automatically hide rows of the questions that do not have an I have 3 tabs - "Intake", "Pre", and "Post'. jlqe, eh9, qu, pi, dcph, ne4wjfg, nnoz, 6234b, vkozkd, 7ez,