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