Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Annoying hidden names
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Annoying hidden 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 jwlabno wrote in message u... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Annoying hidden 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem - hidden cell names in worksheet | Excel Worksheet Functions | |||
Hidden Range Names | Excel Worksheet Functions | |||
How to find hidden names on an Excel worksheet ? | Excel Worksheet Functions | |||
hidden names in active workbook | Excel Worksheet Functions | |||
Annoying bug. | Excel Programming |