Last week, I showed you a quick trick for creating a Defined Name using the Name Box (the control at the left end of the Formula bar). Simply type the name in the Name Box and press [Enter]
The rest is here:
Render an Excel Defined Name invisible to users
Most developers like to document a database and there are a number of built-in features for that purpose. However, as is, you can’t easily document the referenced libraries. You could open the Visual Basic Editor and manually create a list, but there’s an easier way
Read this article:
Office challenge: How can you get a list of libraries referenced in an Access database?
