Activating sheets using Launch

[bobbydave]

So ... I have two buttons on my document which will open the another qlikview application but I want the two buttons to activate one sheet from the application, the second button to open the second sheet from the application.

e,g,

So I have a Department application that has Button A and Button B and a Department application.

When I click on Button A, this should open Premiums sheet of the department application and Button B should launch the Claims sheet of the department application.

Is there any way to do so. I can launch the external applicaiton with the trigger but its Activating the Sheet I want opened is the problem.

Any help appreciated.

[bobbydave]

This is exactly what I needed.

I am not too familiar with macros but this does exactly what I needed.

Thanks Robert

[bobbydave]

Thanks but this would only open the same sheet.

[robert_mika]

Go to Tolls-->Edit Module and add the above code.

Then assign one for each button.

I'm sure it will work

[bobbydave]

It does. I used it. And worked Magically.

Thanks again

[bobbydave]

My next thing though is because it opens the same application, the two sheets are visible and I only want the Claims sheet to be visible (the Premiums tab will be hidden) when opening the Claims button and the Premiums button shows the Premiums tab (hiding the Claims tab).

Do you think section access applied to a button would work?

I've tried conditional formatting to hide these but wont work

In your macro, you have activate sheet; is there a deactivate sheet alternative?

[rwunderlich]

If the trigger Action was Launch, you could use the sheet parameter?

-Rob