Need Help

[paulwalker]

Hi EveryOne,

I need one help, i have 3 sheets..

i want to see all sheets(Sheet1, sheet2 and sheet3), but if anyone use this application they will see only 2 sheets(sheet1 and sheet2).

is there any solution???

[saurabh5]

hi Paul,

i found an example to dynamically hide and show sheets, have a look at the attached qvw. if that helps !

Regards

Saurabh

[paulwalker]

Suppose i have permissions

NTNAME, SH01,SH02,SH03

Domain/Test, 1,1,1

Domain/Test1,1,1,0

Domain/Test2,1,1,0

Domain/Test3,1,1,0

Domain/Test4,1,1,0

Suppose i have 100 of users, should i write 100 users???

is there any other method??/

Please anyone give example..........

[#4]

I have had a request for something verify similar and was able to accomplish with condition on sheet based on OSUser

bELOW WILL ALLOW JUST USER 1 AND USER 2 ACCESS TO THE SHEET

=UPPER(OSuser())='DOMAIN/USER1
OR UPPER(OSuser())='DOMAIN/USER2'