Using code to delete a named range

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?

Please Login or Register  to view this content.

The option to prompt for the name works great and is a cleaner way to perform it, thank you for both suggestions. I did find however that access to the Name Manager opens up if the user can open a new worksheet or switch to one that is unprotected. Seems the Name Manager is only as protected as the worksheet you are currently on, but the button makes the whole process work perfectly either way.

Another thought: You need to deal with the case where the user enters a name that doesn't exist.