Re: Remove a Defined Name

Dave,

Thank you very much for your help.

First of all, the define name is gone, even the ones that are hidden (using
the "Name Manager.xla"). I don't know how she created to make those define
names hidden and with a special character. Do you know?

Secondly, I follow your instructions by checking the "R1C1 Reference Style".
Then Excel prompted me for a new name for that special character define
name. After I gave a new name, Excel allowed me to delete the define name.
Can you explain to me what "R1C1 Reference Style" is to prompt the Excel for
a new define name for that special character define name?

Thank you again very much for your helps. Plus, thank you for sharing the
"Name Manager.xla". It is/will be very helpful.

"Dave Peterson" wrote:

That looks like an invalid name--both the vertical bar and the space will cause
an error.

I'd try this:
Tools|options|General|Check R1C1 Reference style
Then click ok
Then change it back
Tools|options|General|uncheck R1C1 Reference style

I'm not sure which action will cause excel to complain about that invalid name,
but at some point, excel will yell at you to use a valid name. Have one handy
(DeleteMeLater)???

Then after you rename that name, you can delete the new name
(insert|name|define).

Since you're working with names, get Jan Karel Pieterse's (with Charles Williams
and Matthew Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

It has this as one of its features (IIRC).

AccessHelp wrote:

Hello,

I have a workbook which contains a defined name "_|_ Print Area". I have
been trying to remove it from the workbook several times, and I can not
remove it.

Does anyone know how to remove it?

Apprently, the defined name is referencing to a file that we created in 1999
and to a file that located in our network.

Thanks.

--

Dave Peterson

.

Relevant Pages

  • Re: Remove a Defined Name
    ... "Dave Peterson" wrote: ... I think earlier versions of excel ... Some people like R1C1 Reference style. ...
    (microsoft.public.excel.programming)
  • Re: Remove a Defined Name
    ... "Dave Peterson" wrote: ... I think earlier versions of excel ... Some people like R1C1 Reference style. ...
    (microsoft.public.excel.programming)
  • Re: Remove a Defined Name
    ... "Dave Peterson" wrote: ... I think earlier versions of excel ... Some people like R1C1 Reference style. ...
    (microsoft.public.excel.programming)
  • Re: RC format formulas
    ... Dave Peterson wrote: ... worksheet). ... Then tools|Options|General tab and check R1C1 Reference style. ... (Let excel do all that work for you!) ...
    (microsoft.public.excel.programming)
  • Re: How do I change column addresses from numeric to alpha?
    ... This is a setting that excel picks up from the first workbook that it opens in ... co-worker likes R1C1 reference style) and you're unlucky enough to open it as ... the first workbook, then you'll want to remember how to change it. ... The old style Excel was formated so that alpha characters were the column ...
    (microsoft.public.excel.setup)