Forum home » Delegate support and help forum » Microsoft Excel Training and help » Defining and Using Name Ranges
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Defining and Using Name Ranges
Resolved · Low Priority · Version 2007
Reply Wed 27 Jul 2011, 16:37Delegate Melissa said...
Melissa has attended:
Excel Advanced course
Defining and Using Name Ranges
how do i create a hidden name range
For upcoming training course dates see: Pricing & availability
RE: 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
Wed 3 Aug 2011: Automatically marked as resolved.
|