Articles

Excel - Unhide all sheets

This little sub quickly unhides all hidden sheets (including xlVeryHidden). I use it frequently as people tend to hide worksheets which are no longer needed rather than just delete them, also especially useful when trying to dissect other peoples creations. It also has some sneaky uses, I regularily come across people who like to protect the   more »