View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Rockee052[_45_] Rockee052[_45_] is offline
external usenet poster
 
Posts: 1
Default ListBox with hidden and visible sheet names?

Hi,

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

Thanks,

Rocke

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