Prevent user from opening names manager

XLS Padlock
1

Hello,

Is there a way to prevent the user from accessing the names manager with XLS Padlock?

Thanks,
Anna.

2

Hello Anna,

I don’t know of a way to prevent the user from accessing the names manager. However, I hid the names with a hide/unhide routine which I run prior to compiling the workbook.

I’ll share it with you…
‘-----------------------------------------------------------------------------------------’
’ This routine is used to hide/unhide all names in the name manager. ’
’ It is called by the WS_Hide-Unhide subroutine. ’
’ ’
’ 10/21/2021 - New procedure. ’
‘-----------------------------------------------------------------------------------------’
’ Excel VBA hide names defined in Name Manager - Stack Overflow

Private Sub Hide_Name_Manager(Hide As Boolean)
Dim xName As Name
On Error Resume Next
’ loop through all names
For Each xName In Application.ThisWorkbook.Names
’ Want to skip the ones that begin with “", they seem internal.
If Left(xName.Name, 1) <> "” Then xName.Visible = Not Hide
Next xName
Err.Clear
End Sub

2 Likes