TM1 Forum

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

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.

"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.

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.