Oct 08 2021 03:44 AM - edited Oct 08 2021 03:45 AM
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.
Oct 10 2021 01:35 AM
@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
Oct 10 2021 02:40 AM