Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Is there a way to create a menu with sub-menu on which the user clicks and is directed to a specific sheet?
Hi,
There are several ways to achieve that. I'd use text objects in one sheet where you create the common menu for all the sheets, then use linked objects to move that menu to the rest of the sheets, saving time instead of copying and pasting.
Hope that helps.
Miguel
Hi, please could you attach an exemple here
Thanks
May you please elaborate the issue of linked objects instead of copying and pasting?
Thank you in advance
Here's an example that might help you, but using a list box with a hierarchical layout. It uses a field trigger to switch sheets.
The Tab select boxes on each tab are linked objects, which I think is what Miguel was referring to - you still need to copy and paste them, but choose Paste Sheet Object as Link.
flipside
PS Ignore the text box on the sheet (legacy of testing)