| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select range of specific hidden worksheet of closed protected work
I've numerous identicle protected workbooks that use a form to populate
various hidden worksheets within the workbook. I'd like to collect the data from the related hidden worksheets for all workbooks in a directory. I'd rather (possibly using ADO) not have to open all the workbooks How do I reference a range in a specific hidden worksheet in a closed protected workbook? Solutions I've researched by Ron De Bruin and others come close perhaps if there is specifications of how to programmatically reference a range past... Protected Workbook Protected Worksheet Hidden worksheet I'll have what I need to continue -- Jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make calculations work with one worksheet closed | New Users to Excel | |||
| HYPERLINK() FOR A SPECIFIC CELL IN A CLOSED WORK BOOK & SHORTCUT | Excel Discussion (Misc queries) | |||
| Send data to a specific worksheet in a closed Workbook | Excel Programming | |||
| Edit specific range in protected worksheet | New Users to Excel | |||
| Can specific cells on a worksheet be hidden & password protected? | Excel Worksheet Functions | |||
Threaded Mode
