Unable to Delete Named Objects

[lovecolorado]

I'm new to using Names in Excel and was using some code without fully understanding it. As a result, I have added definitions of several Names that are assigning fixed values when I want to change the value.

Since these Names were created without my understanding, I want to delete them and then create them more carefully. Unfortunately, when I go into 'Name Manager', the 'Delete' button is grayed out for several Names, per the following screen-capture:
Names.png

I tried running the following code to delete the Names, but it hung on the second line of code:

Please Login or Register  to view this content.

Does anyone have a solution to delete the Names?

[Keebellah]

Is the worksheet protected or something?

[lovecolorado]

Bingo! That was it. Thank you!

I don't get why "that was it". The workbook has four worksheets. Six columns on one of the worksheets were protected. None of the Named objects were used in the six protected columns, but unprotecting those columns still somehow enabled me to delete all of the Named objects.

[Keebellah]

It has to do with the fact that one or more where protected.
Even if the named range is outside the locked cells.
When protecting there are options that allow or permit modifying parts of worksheets etc.
Check that to clarify, like e.g. Autofilter must be enabled when you protect a worksheet
Don't forget to mark the post solved

[lovecolorado]

Thank you for getting back to me on the 'why' issue!

Re "It has to do with the fact that one or more where protected.": This is obviously true, because your suggestion to unprotect the worksheet enabled me to delete the Named objects. However, can you be more specific about why this worked "Even if the named range is outside the locked cells"?

Re "When protecting there are options that allow or permit modifying parts of worksheets etc.": Agreed, and I tried to choose 'good' options; e.g., I checkmarked:

• Protect Worksheet and contents with locked cells
• Select unlocked cells
• Format cells
• Edit objects
• Edit scenarios

Would you suggest a different set of options to checkmark? If 'yes', why?

Re "Autofilter must be enabled when you protect a worksheet": Why is this?

[Keebellah]

That's for you to decide and what you want to allow the user's to do.
If you're using macro's there is an extra option to add when protecting the worksheet(s) using vba and that is UserInferceOnly:=True.
This allows the VBA to modify any cell and keeps it locked for the users and you do not need to unprotect and protect the worksheet every time the macro runs.
Look it up on Google for more about protecting and un protecting worksheets using VBA

[lovecolorado]

Thank you for your help.

[Keebellah]

Glad to have been able to