If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to delete all defined names from a workbook?
Hello
How to delete all defined names from a workbook? |
#2
|
|||
|
|||
How to delete all defined names from a workbook?
|
#3
|
|||
|
|||
How to delete all defined names from a workbook?
Use the Name manager by Jan Karel Pieterse.
You download it he http://www.jkp-ads.com/Download.htm -- Kind regards, Niek Otten "Dmitry Kopnichev" wrote in message ... Hello How to delete all defined names from a workbook? |
#4
|
|||
|
|||
How to delete all defined names from a workbook?
Thank you!
"sfby" ???????/???????? ? ???????? ?????????: oups.com... The Name manager add in is very useful... http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.htm |
#5
|
|||
|
|||
How to delete all defined names from a workbook?
VBA
Sub DeleteNames() Dim nme As Name For Each nme In ActiveWorkbook.Names nme.Delete Next nme End Sub Here is another way, previously posted by Norman Harker. But beware, it doesn't work with Excel 2003. And here's a best kept secret of Excel but it comes with a health warning. Tools Options Transition Check Lotus 123 Help Check Transition Navigation Keys Now: /RNR Removes every single name in the workbook! Beats doing them one at a time although you can use VBA or various Add-Ins. But it really ought to come with a health warning after the /RNR command as it can't be undone! And with many hundreds of names in a workbook Just close the Names dialog box when it comes up -- HTH RP (remove nothere from the email address if mailing direct) "Dmitry Kopnichev" wrote in message ... Hello How to delete all defined names from a workbook? |
#6
|
|||
|
|||
How to delete all defined names from a workbook?
This will do it.
Sub DeleteAllNames() 'ALL sheets For Each Name In Names Name.Delete Next Name End Sub or Sub DeleteHiddenNames() Dim n As Name Dim Count As Integer For Each n In ActiveWorkbook.Names If Not n.Visible Then n.Delete Count = Count + 1 End If Next n MsgBox Count & " hidden names were deleted." End Sub Don Guillett SalesAid Software "Dmitry Kopnichev" wrote in message ... Hello How to delete all defined names from a workbook? |
#7
|
|||
|
|||
How to delete all defined names from a workbook?
The Name manager caused Excel to shut down without saving files. The error
appeared when I tried to delete inoperable names. "Niek Otten" сообщил/сообщила в новостях следующее: ... Use the Name manager by Jan Karel Pieterse. You download it he http://www.jkp-ads.com/Download.htm -- Kind regards, Niek Otten "Dmitry Kopnichev" wrote in message ... Hello How to delete all defined names from a workbook? |
#8
|
|||
|
|||
How to delete all defined names from a workbook?
Be careful.
Excel creates names that it uses (without your knowledge and without your permission). If you delete those names, you could be breaking something that excel needs. If I were you, I'd get a copy of 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 You can delete just the names you want pretty easily. Dmitry Kopnichev wrote: Hello How to delete all defined names from a workbook? -- Dave Peterson |
#9
|
|||
|
|||
How to delete all defined names from a workbook?
You may want to contact Jan Karel:
http://www.jkp-ads.com/Contact.htm If the file doesn't contain any proprietary information, I'm sure he would like to have a copy (confirm with him first) so that he can see the problem. If the file does contain proprietary info, maybe you can clean it up so that the data is gone, but the problem is still there???? Dmitry Kopnichev wrote: The Name manager caused Excel to shut down without saving files. The error appeared when I tried to delete inoperable names. "Niek Otten" сообщил/сообщила в новостях следующее: ... Use the Name manager by Jan Karel Pieterse. You download it he http://www.jkp-ads.com/Download.htm -- Kind regards, Niek Otten "Dmitry Kopnichev" wrote in message ... Hello How to delete all defined names from a workbook? -- Dave Peterson |
#10
|
|||
|
|||
How to delete all defined names from a workbook?
I do not try again yet.
"Dave Peterson" ???????/???????? ? ???????? ?????????: ... You may want to contact Jan Karel: http://www.jkp-ads.com/Contact.htm If the file doesn't contain any proprietary information, I'm sure he would like to have a copy (confirm with him first) so that he can see the problem. If the file does contain proprietary info, maybe you can clean it up so that the data is gone, but the problem is still there???? Dmitry Kopnichev wrote: The Name manager caused Excel to shut down without saving files. The error appeared when I tried to delete inoperable names. "Niek Otten" сообщил/сообщила в новостях следующее: ... Use the Name manager by Jan Karel Pieterse. You download it he http://www.jkp-ads.com/Download.htm -- Kind regards, Niek Otten "Dmitry Kopnichev" wrote in message ... Hello How to delete all defined names from a workbook? -- Dave Peterson |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
not delete worksheets from names in a range | DARREN FONG | General Discussion | 3 | November 11th, 2005 05:31 PM |
Using Defined Names in a Chart | bobburg | General Discussion | 2 | September 12th, 2005 12:07 AM |
CHANGE COLUMN NAMES TO DEFINED NAMES | David @ Elite | General Discussion | 1 | October 5th, 2004 04:29 PM |
Problem with Defined Names | Joe Blow | Worksheet Functions | 1 | October 1st, 2004 05:57 PM |
Defined Names in an If Statement | SharonSmith | Worksheet Functions | 3 | March 25th, 2004 04:04 PM |