Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
I had created following script but several problems encountered :
1. System asked for UserID but it did not ask for password.
2. System should allow Admin to access all Sheets, User C to access Sheet3 only but it allows User C to access all Sheets.
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD
Admin, Admin, admin
User, A, a
User, B, b
User, C, c
];
Section Application;
LOAD * INLINE [
USERID, SHEET
Admin, ALL
A, Sheet1
B, Sheet2
C, Sheet3
];
Thank You
Tracy
Hi In Section application
Give like this
LOAD * INLINE [
USERID, [Sheet ID]
Admin,
A, SH01
B, SH02
C, SH03
];
Then make shore click "Scrict Exclution" in document properties
The reason for this behaviour is that there are no data which are connected with the section access - if you add one (like in the attachement) you will be queried for the password. Here you will find many informations about Section Access.
- Marcus
Hi Tracy, in document properties (CTRL+ALT+D)-->'On Open' tab--> Check the 'Initial Data Reduction Based on Section Access'.
This will restrict the SHEET field values each user can see. And also it will start asking for password.
The other way to restrict using the sheets are the conditions in Sheet properties.
Hi
Please see the attached document.. hope this helps
Sasi