Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, How do you make certain user to only see certain pages(sheets)? e.g User1 - User10 only see sheet1 and User11 - User 15 sees sheet2. reading the users from the excel file.
Regards
Edzi
see the attached file
user id and password -> admin and admin
hope this helps
Hi
see the attached file
user id and password -> admin and admin
Hi Sunil
Thanks for replyin
what are the password for user1 - user5, I see the Admin user can access all other sheets but I wanted to check if the other users can only view the sheets they are supose to view.
and the other thing, using the excel file, shuold my column looks like this so that I can assign the sheets in which the user has to view?
ACCESS, USERID, PASSWORD, SHEETID
ADMIN, ADMIN, 1, *
USER, USER1, 1, SH01
Regards
Edzi
sorry i forgot to give you hidden script password
file menu -> edit hiden scrpt- 123 ok will show you code for section access.
from there you can see all the userid and password.
same thing you can implement in excel also
hope this helps
Thanks I managed to view the hiden script.
I was trying to load the data to assign the sheets to users but the users always view all the sheets when i test my model, can you please send me an example where the users are assigned the sheets from the excel file if posible?
Unfortunatley i cannot manage to get it working.
Regards
Edzi
one option you need to check
document properties-> opening->Initial data reduction based on section access->chck it
see the attached file
hope this help
Hi Perumal
what I want is to load the sheets in which a certain user has to access and the log in details of the user from the excel file.
Regards
Edzi
Hi,
I Can't understand little Explain.
Regards
Perumal A
Hi
Please see the attachment for more clarity,
I used the groups to show which user has to access which page(sheet) on this example each user has to access one sheet!
Please use the following for user name and password
Arina
Tondani
Mpho
Regards
Edzi
The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful