| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exclude hidden workbooks from list
I'd like to list all open - but NOT hidden - workbooks in a userform listbox.
However, I am unable to find any properties that tell if a book is hidden or not. You can try to activate each book and test for success, I suppose, but there has to be a more elegant way than that. Isn't there? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude Hidden Row Values | Excel Worksheet Functions | |||
| Copy Worksheet and Exclude Hidden fields | Excel Worksheet Functions | |||
| Exclude data from summary totals when hidden | Excel Worksheet Functions | |||
| Is there a way to exclude hidden rows/columns when printing a doc | Setting up and Configuration of Excel | |||
| Exclude hidden data from summary totals | Excel Discussion (Misc queries) | |||
Threaded Mode
