Defining and Using Name Ranges

Hello Melissa,

Thank you for your question regarding named ranges.

Unfortunately, there is no way of hiding a hidden name directly through Excel. This would have to be done through VBA.

But to point you in the right direction the code would look like this:
Sub HideNames()
ActiveWorkbook.Names("qwerty1").Visible = False

End Sub

The name of your range replaces the "qwerty1" above.

Not sure in what context you would want to hide the named range!


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer