Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can you open to a given tab in an external document using document chaining?
Let's say I have one summary document with three tabs, Summary, Detail 1, and Detail 2, with the latter two empty
I also have another with three tabs, Summary, Detail 1, and Detail 2, with the first tab empty.
From the first document, I want to be able to click on Detail 1 and be taken to the Detail 1 tab on the second document, and have Detail 2 take me to Detail 2 on the second document. I would have the Summary tab on the second document take me back to the first document's Summary tab.
I have a current application which has multiple tabs of detail and multiple tabs of summary, and I wish to preserve the number and titles of tabs in each.
I'm not sure if this is possible with Actions, but you should be able to do this with macros by using the ActivateSheet method. See the API Guide for more details.
Regards,