Forum Discussion
VBA to hide rows based on value in cell (multiple criteria)
Hello all, I've made a summary sheet of a questionnaire in a workbook. Not all questions have to be answered, and I'm trying to make a macro that would automatically hide rows of the questions th...
Thanks very much! Apologies for the late reply, I've tried the code but it doesn't seem to be working. Not sure what the problem could be, but it's not executing.
Try the attached version. I also added a Workbook_Open event procedure to the ThisWorkbook module.
Since it is now a macro-enabled workbook (.xlsm), you'll have to allow macros when you open it.