Re: List of all names in EXCEL workbook

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: NameSearcher (NameSearcher_at_discussions.microsoft.com)
Date: 03/07/05 

Date: Mon, 7 Mar 2005 08:01:07 -0800

Suggestion is on point but I can't seem to bring up the sequence. I have
EXCEL 2000. I have tried the Tools\Customize\ command and tried to set up a
custom menu bar with the Insert List but I haven't been able to get it to
work. Maybe walk me through it slower. Thanks.

"arno" wrote:

> Menu Insert/Names/Insert/Insert List
>
> arno
>
> "NameSearcher" <NameSearcher@discussions.microsoft.com> schrieb im
> Newsbeitrag news:6A01CCCC-5484-4684-8316-FF376F5B7B20@microsoft.com...
> > How do I get a list of all the names being used in an EXCEL workbook?
> The
> > "Insert\Names... " sequence of commands gets a list you can view on
> the
> > screen, about 10 at a time. I would like to copy/paste the whole
> list. I
> > would also like the list to include (as a separate column) associated
> text
> > showing the references for each name.
>
>

Relevant Pages

  • Re: Command Button Color Palette
    ... How do I find the color index value (i.e. for the "gold" color square ... BackColor property and select the Palette tab. ... When I go into the properties for the Command Button while in design mode, ... Excel shows a similar color palette, but not with the exact same colors as ...
    (microsoft.public.excel.programming)
  • Re: Add-In Excel Locked Up
    ... Note that Excel 2007 does not have a menubar or toolbars. ... command. ... Dim Ms As CommandBarControl ... Dim CoreCons As CommandBarButton ...
    (microsoft.public.excel.programming)
  • Re: Printing prn files
    ... I have no idea how setting a print area in Excel could relate to the problem ... Windows does not provide a way to do this directly. ... > is to use a command issued from a command processor prompt. ...
    (microsoft.public.windowsxp.print_fax)
  • RE: Prevent Printing in Print Preview?
    ... *Go to the Visual Basic Editor (from Excel, ... *In the Project Explorer, expand the "tree" for the VBA project that you ... The command button has code that gives the ...
    (microsoft.public.excel.programming)
  • Re: Nag message on excel installation with Vista
    ... The old ways are still the best; lovely to use the command ... nag screens in Excel now. ... Havn't found Start/Run in Vista but the comand prompt can be accessed frm ... "Dave Peterson" wrote in message ...
    (microsoft.public.excel.setup)