Linking to specific tabs in other workbooks

[Guest]

Is there a way to allow our boss to open an Excel workbook and select to see
a specific tab from another workbook of one of our many offices? I would like
to embed it, unless there is a better way. I do not want to have another
instance of Excel to open.

Hopefully more info if the top is not enough
We are creating a workbook that involves many tabs. In this workbook, there
is a tab that summarizes all the other tabs in one view. There are six
offices that will each have their own workbooks with all these tabs. We would
like to create another workbook, that consists of only one tab, that the boss
can have a dropdown and select which summary tab he wants to see and see that
specific tab.

 

[Jim Cone]

One way would be to put copies of all of the sheets from the other
workbooks in the boss workbook and hide them. When the boss
clicks something then a particular sheet is shown.
The boss could update the workbook automatically (using an update
button) if all the workbooks were in a common file structure.
Ron de Bruin has some sample code here...
http://www.rondebruin.nl/tips.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Mike Collins" <[email protected]>
wrote in message
Is there a way to allow our boss to open an Excel workbook and select to see
a specific tab from another workbook of one of our many offices? I would like
to embed it, unless there is a better way. I do not want to have another
instance of Excel to open.

Hopefully more info if the top is not enough
We are creating a workbook that involves many tabs. In this workbook, there
is a tab that summarizes all the other tabs in one view. There are six
offices that will each have their own workbooks with all these tabs. We would
like to create another workbook, that consists of only one tab, that the boss
can have a dropdown and select which summary tab he wants to see and see that
specific tab.