View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
billinr billinr is offline
external usenet poster
 
Posts: 38
Default Hide or unhide sheets based on cell

Would someone be able to provide a suggestion as to how to hide and / or
unhide a group of sheets based on a cell content?
I have a cell that selects a model from a drop down list; I would like to
hide all the sheets not related to this value.
When the value changes, I would like the corresponding sheets to be
un-hidden, and the non-related sheets to go away.
There will be certain sheets that will be visible at all times.

Is this possible?

Thanks