How can I delete names in my workbook that behave like ghosts? When I open
name manager, there are no defined names. But when I copy a sheet, the
message, "A formula or sheet you want to copy contains the name 'fxb' (or
other) which already exists on the destination worksheet..." appears.

I am using Office 2007 with Excel.

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

TKS_Mark wrote:

How can I delete names in my workbook that behave like ghosts? When I open
name manager, there are no defined names. But when I copy a sheet, the
message, "A formula or sheet you want to copy contains the name 'fxb' (or
other) which already exists on the destination worksheet..." appears.

I am using Office 2007 with Excel.

--

Dave Peterson

Is there anyway to clean up these invisible names without resorting to
loading macros?

"Dave Peterson" wrote:

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

TKS_Mark wrote:

How can I delete names in my workbook that behave like ghosts? When I open
name manager, there are no defined names. But when I copy a sheet, the
message, "A formula or sheet you want to copy contains the name 'fxb' (or
other) which already exists on the destination worksheet..." appears.

I am using Office 2007 with Excel.

--

Dave Peterson

I don't think so.

The only way I know to make a name visible is by using code--either a macro that
I load (like NameManager) or code that I write.

(I'm not sure how xl2007 works, though. Maybe there's something on the user
interface for this--but that would kind of defeat the purpose of allowing the
developer to hide names.)

TKS_Mark wrote:

Is there anyway to clean up these invisible names without resorting to
loading macros?

"Dave Peterson" wrote:

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

TKS_Mark wrote:

How can I delete names in my workbook that behave like ghosts? When I open
name manager, there are no defined names. But when I copy a sheet, the
message, "A formula or sheet you want to copy contains the name 'fxb' (or
other) which already exists on the destination worksheet..." appears.

I am using Office 2007 with Excel.

--

Dave Peterson


--

Dave Peterson