Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
is it possible to hide sheet from certain people by their domain name(Log in) , how can I do this
I would like Sheet1 from hidden from certain. Can someone help me set this up, I will learn from the example and mirror.
I want to hide the sheet not the object or tables within. Just to clarify
Hi,
You can even go for section access in the appln as below
I. Create Section Access
SECTION ACCESS;
LOAD * INLINE [
USERID,PASSWORD, ACCESS
ADMIN,123, ADMIN
USER1,123,USER
USER2,125,USER
];
SECTION APPLICATION;
LOAD * INLINE [
USERID,SHEETID
USER1,SH01
USER2,SH02
];
Mike
Use following Condition
Sheet Properties - General - Show Sheet- Conditional
WildMatch(Subfield(OSUse(),'\',2),'Domain Name')>=1
Raman
Hey Mike try this
Right click sheet properties > In conditional give 0 > OK
now the sheet is hidden.
To see the same again you follow the steps to
settings > Document properties > Sheet tab > select the hidden sheet > Properties > In show sheet Remove conditional=0 and tick Always > Ok
Is it possbile to do this by the person computer login .
I want to assign access based on their network path