Annoying hidden names

  • Thread starter Thread starter jwlabno
  • Start date Start date
J

jwlabno

Hello
I have a problem with hidden names/ranges

I use macros to copy sheets from one workbook to another. The destination workbook, when open, asks if it should update links. I am trying to prepare each sheet before copying so that they can be used without external references. I ran utility to display links and it came up with this

Object Name Value
hidden Name Notes!_Table1_In1 ='C:\Data\!Shares\[1-Paper.xls]#REF'!$C$37

The object is not in Names collection and I searched all sheets for C:\ but excel can not find it.
Does anyone know what else can I check to get rid of the message on open?
HOw can I unhide these names?
 
for each nm in Thisworkbook.names
nm.Visible = True
Next

I suspect it is in the names collection, but is hidden.

--
Regards,
Tom Ogilvy

Hello
I have a problem with hidden names/ranges

I use macros to copy sheets from one workbook to another. The destination
workbook, when open, asks if it should update links. I am trying to prepare
each sheet before copying so that they can be used without external
references. I ran utility to display links and it came up with this

Object Name Value
hidden Name Notes!_Table1_In1
='C:\Data\!Shares\[1-Paper.xls]#REF'!$C$37

The object is not in Names collection and I searched all sheets for C:\ but
excel can not find it.
Does anyone know what else can I check to get rid of the message on open?
HOw can I unhide these names?
 
Two utilities that you'll learn to love:

Jan Karel Pieterse, Charles Williams and Matthew Henson's utility called
NameManager.Zip from http://www.bmsltd.co.uk/mvp

and

Bill Manville's findlink.zip from:
http://www.BMSLtd.co.uk/MVP/Default.htm
jwlabno wrote:

Hello
I have a problem with hidden names/ranges

I use macros to copy sheets from one workbook to another. The destination
workbook, when open, asks if it should update links. I am trying to prepare
each sheet before copying so that they can be used without external
references. I ran utility to display links and it came up with this

Object Name Value
hidden Name Notes!_Table1_In1
='C:\Data\!Shares\[1-Paper.xls]#REF'!$C$37
The object is not in Names collection and I searched all sheets for C:\ but
excel can not find it.
Does anyone know what else can I check to get rid of the message on open?
HOw can I unhide these names?
Click to expand...
 
Back
Top