How to delete all defined names from a workbook? "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> 11.11.2005 13:18:48 Hello How to delete all defined names from a workbook?

Re: How to delete all defined names from a workbook? "sfby" <pnc1962-groups[ at ]yahoo.co.uk> 11.11.2005 13:46:08 The Name manager add in is very useful... http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.htm

Re: How to delete all defined names from a workbook? "Niek Otten" <nicolaus[ at ]xs4all.nl> 11.11.2005 13:49:00 Use the Name manager by Jan Karel Pieterse. You download it here: http://www.jkp-ads.com/Download.htm -- Kind regards, Niek Otten "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message news:%23fyV1Js5FHA.2576[ at ]TK2MSFTNGP09.phx.gbl... [Quoted Text] > Hello > How to delete all defined names from a workbook? > >

Re: How to delete all defined names from a workbook? "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> 11.11.2005 13:54:11 Thank you! "sfby" <pnc1962-groups[ at ]yahoo.co.uk> ???????/???????? ? ???????? ?????????: news:1131716768.467125.187170[ at ]g49g2000cwa.googlegroups.com... [Quoted Text] > The Name manager add in is very useful... > > http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.htm >

Re: How to delete all defined names from a workbook? "Bob Phillips" <bob.phillips[ at ]notheretiscali.co.uk> 11.11.2005 14:00:00 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" <kopn[ at ]bk.ruDelete> wrote in message news:%23fyV1Js5FHA.2576[ at ]TK2MSFTNGP09.phx.gbl... [Quoted Text] > Hello > How to delete all defined names from a workbook? > >

Re: How to delete all defined names from a workbook? "Don Guillett" <donaldb[ at ]281.com> 11.11.2005 14:02:02 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 donaldb[ at ]281.com "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message news:%23fyV1Js5FHA.2576[ at ]TK2MSFTNGP09.phx.gbl... [Quoted Text] > Hello > How to delete all defined names from a workbook? > >

Re: How to delete all defined names from a workbook? "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> 11.11.2005 14:06:59 The Name manager caused Excel to shut down without saving files. The error appeared when I tried to delete inoperable names. "Niek Otten" <nicolaus[ at ]xs4all.nl> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:%23wLtoas5FHA.3296[ at ]TK2MSFTNGP09.phx.gbl... [Quoted Text] > Use the Name manager by Jan Karel Pieterse. > You download it here: > > http://www.jkp-ads.com/Download.htm > > -- > Kind regards, > > Niek Otten > > "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message > news:%23fyV1Js5FHA.2576[ at ]TK2MSFTNGP09.phx.gbl... > > Hello > > How to delete all defined names from a workbook? > > > > > >

Re: How to delete all defined names from a workbook? Dave Peterson <petersod[ at ]verizonXSPAM.net> 11.11.2005 14:31:02 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: [Quoted Text] > > Hello > How to delete all defined names from a workbook? -- Dave Peterson

Re: How to delete all defined names from a workbook? Dave Peterson <petersod[ at ]verizonXSPAM.net> 11.11.2005 14:37:18 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: [Quoted Text] > > The Name manager caused Excel to shut down without saving files. The error > appeared when I tried to delete inoperable names. > "Niek Otten" <nicolaus[ at ]xs4all.nl> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: > news:%23wLtoas5FHA.3296[ at ]TK2MSFTNGP09.phx.gbl... > > Use the Name manager by Jan Karel Pieterse. > > You download it here: > > > > http://www.jkp-ads.com/Download.htm > > > > -- > > Kind regards, > > > > Niek Otten > > > > "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message > > news:%23fyV1Js5FHA.2576[ at ]TK2MSFTNGP09.phx.gbl... > > > Hello > > > How to delete all defined names from a workbook? > > > > > > > > > > -- Dave Peterson

Re: How to delete all defined names from a workbook? "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> 11.11.2005 14:41:48 I do not try again yet. "Dave Peterson" <petersod[ at ]verizonXSPAM.net> ???????/???????? ? ???????? ?????????: news:4374AC9E.6DB7A9AD[ at ]verizonXSPAM.net... [Quoted Text] > 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" <nicolaus[ at ]xs4all.nl> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: > > news:%23wLtoas5FHA.3296[ at ]TK2MSFTNGP09.phx.gbl... > > > Use the Name manager by Jan Karel Pieterse. > > > You download it here: > > > > > > http://www.jkp-ads.com/Download.htm > > > > > > -- > > > Kind regards, > > > > > > Niek Otten > > > > > > "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message > > > news:%23fyV1Js5FHA.2576[ at ]TK2MSFTNGP09.phx.gbl... > > > > Hello > > > > How to delete all defined names from a workbook? > > > > > > > > > > > > > > > > -- > > Dave Peterson

Re: How to delete all defined names from a workbook? "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> 11.11.2005 14:44:03 Thanks. How to know which names Excel created? What exactly could I be breaking that excel needs, if I delete those names? "Dave Peterson" <petersod[ at ]verizonXSPAM.net> ???????/???????? ? ???????? ?????????: news:4374AB26.B07FC6BC[ at ]verizonXSPAM.net... [Quoted Text] > 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

Re: How to delete all defined names from a workbook? "Bob Phillips" <bob.phillips[ at ]notheretiscali.co.uk> 11.11.2005 15:04:02 They usually take the format of *_FilterDatabase *Print_Area *Print_Titles *wvu.* *wrn.* *!Criteria most will recreate next time needed, but not guaranteed. -- HTH RP (remove nothere from the email address if mailing direct) "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message news:e5Otd5s5FHA.3388[ at ]TK2MSFTNGP11.phx.gbl... [Quoted Text] > Thanks. > How to know which names Excel created? What exactly could I be breaking that > excel needs, if I delete those names? > "Dave Peterson" <petersod[ at ]verizonXSPAM.net> ???????/???????? ? ???????? > ?????????: news:4374AB26.B07FC6BC[ at ]verizonXSPAM.net... > > 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 > >

Re: How to delete all defined names from a workbook? Dave Peterson <petersod[ at ]verizonXSPAM.net> 11.11.2005 18:30:25 I sent a message to Jan Karel. He would like to see your workbook. You can send it to him at: jkpieterse[ at ]netscape.net Dmitry Kopnichev wrote: [Quoted Text] > > Hello > How to delete all defined names from a workbook? -- Dave Peterson

Re: How to delete all defined names from a workbook? "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> 14.11.2005 15:17:21 Thanks! What exactly could I be breaking that excel needs, if I delete those names? "Bob Phillips" <bob.phillips[ at ]notheretiscali.co.uk> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:O9rLqEt5FHA.4076[ at ]tk2msftngp13.phx.gbl... [Quoted Text] > They usually take the format of > > > *_FilterDatabase > *Print_Area > *Print_Titles > *wvu.* > *wrn.* > *!Criteria > > most will recreate next time needed, but not guaranteed. > > -- > > HTH > > RP > (remove nothere from the email address if mailing direct) > > > "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> wrote in message > news:e5Otd5s5FHA.3388[ at ]TK2MSFTNGP11.phx.gbl... > > Thanks. > > How to know which names Excel created? What exactly could I be breaking > that > > excel needs, if I delete those names? > > "Dave Peterson" <petersod[ at ]verizonXSPAM.net> ???????/???????? ? ???????? > > ?????????: news:4374AB26.B07FC6BC[ at ]verizonXSPAM.net... > > > 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 > > > > > >

Re: How to delete all defined names from a workbook? "Dmitry Kopnichev" <kopn[ at ]bk.ruDelete> 14.11.2005 15:20:29 Thanks! Does not publishing an e-mail address in a message a group cause spam to the address? "Dave Peterson" <petersod[ at ]verizonXSPAM.net> ???????/???????? ? ???????? ?????????: news:4374E341.7967D575[ at ]verizonXSPAM.net... [Quoted Text] > I sent a message to Jan Karel. He would like to see your workbook. > > You can send it to him at: jkpieterse[ at ]netscape.net > > > > > > Dmitry Kopnichev wrote: > > > > Hello > > How to delete all defined names from a workbook? > > -- > > Dave Peterson

Re: How to delete all defined names from a workbook? Dave Peterson <petersod[ at ]verizonXSPAM.net> 14.11.2005 15:26:17 Jan Karel told me it was ok to post that address. (I would have munged it, too.) Dmitry Kopnichev wrote: [Quoted Text] > > Thanks! > Does not publishing an e-mail address in a message a group cause spam to the > address? > "Dave Peterson" <petersod[ at ]verizonXSPAM.net> ???????/???????? ? ???????? > ?????????: news:4374E341.7967D575[ at ]verizonXSPAM.net... > > I sent a message to Jan Karel. He would like to see your workbook. > > > > You can send it to him at: jkpieterse[ at ]netscape.net > > > > > > > > > > > > Dmitry Kopnichev wrote: > > > > > > Hello > > > How to delete all defined names from a workbook? > > > > -- > > > > Dave Peterson -- Dave Peterson