Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I want to hide a sheet depending on the user. It only needs to be based on a list of allowed user names, I not concerned with permissions or authorities or anything like that.
I've tried using OSUSER() in a macro but it doesn't seem to return anything.
Any ideas?
Thanks.
On the Sheet properties - General tab, Show Sheet option, select Conditional radio button, and give the condition as OSUser = "DOMAIN\USER_NAME". This should work.
Also, make sure that the Document's Security setting - "Show All Sheets and Objects" is cleared.