| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selected Sheets
I have a workbook that contains 25 worksheets. Suppose I select sheets 12,
15, and 21 Is there a way - programmatically - to cycle thru the sheets collection and identify which ones have been selected? I can count the number of sheets selected with: SelectedSheets = ActiveWindow.SelectedSheets.Count but I can't seem to find where I can read which ones are selected. Glen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to run on selected sheets | Excel Discussion (Misc queries) | |||
| Printing selected sheets. | Excel Worksheet Functions | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
| Multiple sheets selected | Excel Discussion (Misc queries) | |||
| printing selected sheets | Excel Programming | |||
![Glen Mettler[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
