This macro was developed for an application where there were 12 tables on a worksheet, one for each month. Only one of these tables needed to be visible at a time. So, we set up a validation dropdown with the 12 months in the list. One clicks on the month one wants in the dropdown and the corresponding table is displayed. All others are hidden. Of course, this little gadget has a million possible uses. Therefore I added a few parameters to make it easily adaptable to different applications.
The attached file has full instructions for installation and deployment. It also serves to demonstrate a very different application than the one described above. Have a look!