Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a requirement to hide few sheets depending on the user logging into the access point to view the app. I'm trying to implement section access but so far not successful. If I check the strict exclusion, none of the users are able to access the app in the access point. It says..the user don't have the permission.
If I uncheck the strict exclusion, All the tabs are visible to all the users. Please advise what am I missing here. Attached is the excel.
Section Access;
LOAD NTNAME,
USER_ID
FROM
[..\ExternalData\SA_JMPN_Exec.xlsx]
(ooxml, embedded labels, table is Section_Access);
Section Application;
LOAD NTNAME,
USER_ID,
SH01,
SH03,
SH04,
SH05,
SH06,
SH07,
SH08
FROM
[..\ExternalData\SA_JMPN_Exec.xlsx]
(ooxml, embedded labels, table is Section_Access);
And this: