Hiding an ActiveForm Tab in TM1 Web

[smish]

Hi all,

I have an ActiveForm (call it my_file.xlsx) with a few workbook tabs. One of them is an "Admin" tab (which I am trying to "hide" if you are not logged in as Admin).
I have tried following this: http://www-01.ibm.com/support/docview.w ... wg21612864 (right click on my Applications folder, select security assignments,
select the websheet (my_file.xlsx.blob) and setting {tp_Everyone group to have no access).

Sadly, when I log into TM1 Web as a non Admin user, I can still see the Admin tab.

Can anyone help please?

Thanks,

Smish

[lotsaram]

You can't do this in Excel without VBA to hide the tab. Why on earth would you think there was even a possibility of achieving this in tm1 web? (There isn't)

The best you can do is give users no access to content on the admin tab and/or conditionally format so the users don't see any content. But the tab will always be there.

[smish]

"Why on earth would you think there was even a possibility of achieving this in tm1 web?".....
Because I am new to it all and, in theory at least, it's not a complicated scenario...but thanks for
responding & your suggestion.

[declanr]

You can split the workbook into individual books (websheets) and create a navigation between them using the URL api inside a hyperlink() excel function - add an if statement that works out whether they are in the admin group/s and if not use the display name of blank and then they wont get the hyperlink.

You could also do something similar with action buttons.