NAMED MANAGER should have user id and password!

%3CLINGO-SUB%20id%3D%22lingo-sub-2826465%22%20slang%3D%22en-US%22%3ENAMED%20MANAGER%20should%20have%20user%20id%20and%20password!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2826465%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%2C%20it%20is%20requested%20that%20in%20NAMED%20MANAGER%2C%20there%20must%20be%20user%20id%2C%20password%2C%20so%20our%20formulas%20couldn't%20be%20seen%20by%20the%20user%2C%20and%20they%20cannot%20go%20inside%20NAME%20MANAGER%20and%20see%20the%20formulas%20etc.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2826465%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2830917%22%20slang%3D%22en-US%22%3ERe%3A%20NAMED%20MANAGER%20should%20have%20user%20id%20and%20password!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2830917%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1015056%22%20target%3D%22_blank%22%3E%40Al-Ahdal%3C%2FA%3E%2C%26nbsp%3Bwhile%20Microsoft%20meets%20your%20demand%2C%203-4%20years%20from%20now%2C%20you%20can%20use%20this%20macro%20to%20hide%20the%20defined%20names%2C%20and%20their%20formulas%2C%20in%20the%20named%20manager.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-visual-basic%22%3E%3CCODE%3ESub%20HideNames()%0A%20%20%20%20Dim%20xName%20As%20Name%0A%20%20%20%20For%20Each%20xName%20In%20Application.ActiveWorkbook.Names%0A%20%20%20%20%20%20%20%20xName.Visible%20%3D%20False%0A%20%20%20%20Next%0AEnd%20Sub%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EPedro%20Wave%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi, it is requested that in NAMED MANAGER, there must be user id, password, so our formulas couldn't be seen by the user, and they cannot go inside NAME MANAGER and see the formulas etc.

2 Replies

@Al-Ahdal, while Microsoft meets your demand, 3-4 years from now, you can use this macro to hide the defined names, and their formulas, in the named manager.

 

Sub HideNames()
    Dim xName As Name
    For Each xName In Application.ActiveWorkbook.Names
        xName.Visible = False
    Next
End Sub

 

Regards,

Pedro Wave

Thanks Pedro Wave for the response. I tried this, but the issue is that, I myself cannot use this in the formulas because it is disabled and couldn't be used in the formulas. What I need is that, it should not be visible in the NAME MANAGER but I can able to use it in the formula.

MS should provide this functionality, like NAME MANAGER should have user id, password. So that when someone make formulas, it couldn't be seen by the other user.