Button with pass word enter to access certain page

[paulyeo11]

Hi All

I have a sheet which is important information only access by top mgt people , and when user click the button , it will ask for pass word . may i know how to do it ?

Paul

[#2]

Can't you use section acess, then when your user opens the doc and type his password, he will see the tab or it will be hidden ? You can show/hide the tab with a condition on the user type I think.

I don't know exactly how it works in details, but i'm sure it's possilbe

[#3]

See the attached exemple

My 2 users are

id : ID1, pass : PASS1 (owns rights)

id : ID2, pass : PASS2  (don't own rights)

My condition is on QVUSER(), Maybe there is a better way to do it on ACCESS but I don't know how.

[paulyeo11]

Hi Sir

Thank you very much for your advise , my access as below :-

Section Access;

LOAD * INLINE [

   SOURCE_SUP,SOURCE, ACCESS, USERID, PASSWORD, NTNAME

    ,, ADMIN, TDSS, 3066, *

    *,*, ADMIN, DEVELOPER, 123, *,*

    TDSS,TDSS, USER, TDS, 1170, *

    *,*, USER, TDSM, 9170, *

    ADL,ADL, USER, ADL, 2171, *

    TDSPG,TDSPG, USER, TPG, 4172, *

    TDSKL,TDSKL, USER, TKL, 5173, *

    TDST,TDST, USER, TDT, 3174, *

    TIS,TID, USER, TID, 6175, *

    *,*, ADMIN, *, *,TDS\demo,*   

    *,*, ADMIN, *, *,TDS\paul yeo,*   

    *,*, ADMIN, *, *,HENDRY\TDS Hendry,*   

    *,*, ADMIN, *, *,Paul\TDS Hendry,*  

    *,*, ADMIN, *, *,Paul\Paul Yeo,*  

    *,*, ADMIN, *, *,Test_8\tds,*

];

section application;

May i know what should i modify the above script in order to hide certain sheet is not able to view by non admin staff ?

Paul

[#5]

Section access would be more secure. Use conditional on sheet properties who could see the sheet.

But if u want to stay on ur initial wish, see attached.

[ariel_klien]

Hi,

Please see the file attached.

change the password to 12345

you can add addition the command OSUser(),

BR

Ariel

[#7]

If you chose to do something like shehele or arielklien propose, be careful

in test.qvw you just have to enter 1=1 in the password box to crack it.

with password.qvw i can't manage to do it, so I don't know

[paulyeo11]

Hi She

Thank you very much , i use your password.qvw , it work fine , but it is possible to make the pass word invisisble , as after enter the pass word it display.

Paul

[paulyeo11]

how come 1=1 can crack ? pls share. i tested she qv password doc 1=1 does not able to crack.

[paulyeo11]

Hi She

after enter the password , and i manage to open the important sheet , may i know how to close it ? or it will automatic close ? any idea ? or do i need to create a button to close the sheet ?