Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created some 'fake' sheets, I want the sheet to open another qvw when people active the tab. I set on open trigger, but it doesn't work. am I missing something? Open doc action works when I have a button. but I want people go straight to another doc by click on the tab itself
It's a bit buried in the Help, but the Open Document action is not available as a Sheet Trigger. Search "Add Action Dialog" in the Help.
Launch and Open URL are not available as Sheet triggers as well, so you can't use them as a workaround. I can think of two alternatives:
1. Hide your tabs and make buttons or Text objects that look like Tabs.
2.
a. Create a button that does the document open action.
b. Create a macro that presses the button.
SUB OpenOther
ActiveDocument.GetSheetObject("BU01").Press
END SUB
c. Have the Sheet Action run the macro.
**Caution -- I haven't tested this idea on the server.
-Rob