Sheet Level Section Access not working

[#1]

Hi Folks,

Sheet level Section access is not working,

1. EditScript > i created the script like below snippet.

2. Before applied the code i enable the "Initial Data reduction on section access" and "Strict Exclusion".

3. reload the data and closed it.

4. now i try to open with user login, but here it was showing 4 sheets.

can some one help me with this..

Thanks in advance..

@Sub2u444

[jagan]

Hi,

In every sheet you have to write a condition in

Sheet Properties -> General -> Show Sheet ->

For SH01:

Only({<SHEETID={'SH01'}>} USERID)

For SH02:

Only({<SHEETID={'SH02'}>} USERID)

[tresesco]

Try like:

To be precise:

Sheet Properties -> General -> Show Sheet ->Conditional : expression

For SH01:

=USERID=Only({<SHEETID={'SH01'}>} USERID)

For SH02:

=USERID=Only({<SHEETID={'SH02'}>} USERID)

[#4]

Hi,

I used the below condition, its not working.

=Only({<SHEETID={'SH01'}>} USERID) -- Sheet1

=Only({<SHEETID={'SH02'}>} USERID) -- Sheet2

Regards,

Sub2u444

[#5]

Hi,

I used the below condition, its not working.

=Only({<SHEETID={'SH01'}>} USERID) -- Sheet1

=Only({<SHEETID={'SH02'}>} USERID) -- Sheet2

Regards,

Sub2u444

[tresesco]

But I suggested something different:

=USERID=Only({<SHEETID={'SH01'}>} USERID)

Your expressing is missing the '=USERID=' part.

[#7]

Hi Tresesco,

=USERID=Only({<SHEETID={'SH01'}>} USERID)

the above expression is working perfectly.

Thanks for your support.

Regards,

Sub2u444

[jagan]

Hi,

Hope this link helps you.

Sheet level access

If you got the answer close this thread by giving Correct and Helpful answers to the posts which helps you.

Regards,

Jagan.

[Anonymous]

your approach is right to create the section access