I have a worksheet that is locked so there does not seem to be a way to permit a user to delete a named range but was hoping that I might be able to get around that restriction by using some code.

I found the following code that works however I'd like to be able to pass a name to the code from what a user enters into a cell. Is there a way to replace the xxx value with a cell reference so a user can type in the name of the range they want to remove from Name Manager into a specific cell?

Sub DeleteName()
     ActiveWorkbook.Names("xxx").Delete
End Sub