Drop down list to Visible/Invisible certain Table

[amirggg]

Hi,

I just wondering to know how can I make a drop-down list to visible a certain table based on my selection and the rest of the tables be invisible?

Thanks

 

[oldbrewer]

first thoughts - colour the cells in all the tables black, and protect the sheet. Run a macro that looks at the drop down selection, goes to appropriate table, unprotects it and removes the blacl color from the cells

You could do this whilst recording a macro to get the code