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