Oct 15, 2014 · Unhiding a lot of sheets is annoying task. So, I've made this Excel VBA macro. This macro unhides all the worksheets in an active workbook. Macro What if you want to make it harder to unhide the sheet? Let’s say you want to reduce the number of visible sheets in the file – reduce the clutter. You also want to make it more difficult for the user to unhide sheets. Follow these steps. Right click a sheet tab and choose View Code – this opens the VBA window. VBA Hide/Unhide only Rows Based on Cell Values not text cell Hi When i m working in this VBA code using in excel sheet hide & unhide rows in cell value . it work in value in cell ride if their any text in this cell its also hide.