ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   importing sheets (https://www.excelbanter.com/excel-programming/317482-importing-sheets.html)

el_peacock

importing sheets
 
Hi

My workbook has a sheet which is an index, referencing a list of other,
hidden, worksheets. The user can unhide the sheets required by clicking a
check box next to the item in the index. This works well, except I have
several items in the list and hence the filesize is reasonably large, as
there is a hidden page for each and every item.

Is there a way to program my index sheet to draw in a worksheet from another
workbook when the user clicks the checkbox, rather than unhiding a sheet. In
this way I hope to keep the workbook size down to the bare minimum of
required sheets.
--
Cheers
---------
Gareth


All times are GMT +1. The time now is 03:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com