Hi Francis,

I have Name Manager 4.0..although I do not know why it is in the Program Files/Microsoft Office/Office 10/Library folder.

Because it is installed there.

a + sign...add a defined name
an icon...update the selected names in the worksheet listing with the information in the worksheet list
an !...refresh the list of names and their refers-to
an i...who created Name Manager

It may be easier to use the text based buttons. On the bottom-right
there is a listbox with checkboxes in it. The last item
in that list says "button icons". Remove the checkbox of that item and
you'll get buttons with textual descriptions.

To copy names from book A to B:

- open book A and B
- with book A active, open the Name Manager and click the "List"
button.
- click no if you want to list all names, click yes to list only the
ones visible in the Name Manager screen
- close name manager
- choose window, arrange, tiled.
- copy the worksheet named "Names 2006-nov-14" (date is today's date)
to workbook B by dragging it from A to B whilst
holding the control key.
- Make sure workbook B is active and start name manager again and click
the pickup button.
- select the names you want included in workbook B.

Note that book B should have all worksheets (which have defined names)
named identically to workbook A

Regards,

Jan Karel Pieterse
JKP Application Development Services
http://www.jkp-ads.com