By this technique we can hide sheets are control depends upon the log on users.
Goto Sheet Properties Under Show Sheet Group box Click Conditional Check box and enter this condition
Single User:
QvUser() = 'HARUN.RASEED'
Multiple User:
QvUser() = 'HARUN.RASEED' or QvUser() = 'GOWRISH'
Goto Sheet Properties Under Show Sheet Group box Click Conditional Check box and enter this condition
Single User:
QvUser() = 'HARUN.RASEED'
Multiple User:
QvUser() = 'HARUN.RASEED' or QvUser() = 'GOWRISH'
No comments:
Post a Comment