Why not have a commandbutton to unhide them all. You could store each that
you unhide in an array, and have another commandbutton to re-hide them.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Rockee052 " wrote in message
...
Hi,

Okay, I have one more question. Would it be possible to use the
listbox_Click() and have each sheet that is hidden temporary unhide,
then hide? So, in other words, when clicking in the listbox, sheets
that are set to hidden would unhide for viewing. I'm trying to clean up
some clutter in a workbook by hidding all but one sheet. Some occasions
I might need to view the hidden sheets.

Thanks,

Rockee


---
Message posted from http://www.ExcelForum.com/