Skip to main content
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. READ MORE

Sheet level access

Showing results for 
Search instead for 
Did you mean: 
Luminary Alumni
Luminary Alumni

Sheet level access

Last Update:

Oct 7, 2022 9:27:44 AM

Updated By:


Created date:

Jul 25, 2013 8:51:40 AM




This document helps in implementing Sheet level access based on the user using Section Access.  I configured four users A, B, C and D and no password is required to login.


If you login as A, then you can see both Sheet1 and Sheet2.

If you login as B, then you can see only Sheet1.

If you login as C, then you can see only Sheet2.

If you login as D, then you can see both Sheet1 and Sheet2.


The user access is defined in the table


UserID Sheet1 Sheet2
A 1 1
B 1 0
C 0 1
D 1 1



Hope this helps others in implementing Sheet level security.




Labels (1)
Partner - Master II
Partner - Master II

what is the user name and password

I downloaded the document and it asks me for a userID

Luminary Alumni
Luminary Alumni

Judging by the filename the UserID is either A, B, C or D and no password is required...

Partner - Contributor II
Partner - Contributor II


Give it an A.

Not applicable


How can i add a prompt message to say to the user when has no access ?


Luminary Alumni
Luminary Alumni

There is no such option if you use section access, you can implement this manually, on Document Open trigger get current user and validate the user identity, if it is valid redirect to the Dashboard sheet otherwise show error message.

Not applicable

Hi all

can anyone please help me, why here i am unable login with user B and C. but i am able to login with A and D

Thank you


Not sure why, but after reloading the application, the login for B and C start working again.

Not applicable

oh gr8 yeah, after reloading it is working.

the funny thing is even my document was not loading with users , and it worked now after reloading now. but, i have reloaded it several times before, but its working now only.

Not applicable


could you please look at it, if you can

Unable to login as User after implementing section access

Not applicable

Thanks for sharing . Good post

Version history
Last update:
‎2022-10-07 09:27 AM
Updated by: