Delete cell names on complete workbook

I have different cells named through out a workbook in different tabs. Is it possible to delete all the named cells without going into each individual cell to delete the name? Thanks!

here are some I use
sub DeleteAllNames() 'ALL sheets
For Each Name In Names
Name.Delete
Next Name
End Sub
Sub DeleteAllNamesBUTprint()
For Each n In Names
If Right(n.Name, 10) <> "Print_Area" _
And Right(n.Name, 12) <> "Print_Titles" _
Then n.Delete
Next n
End Sub
Sub DeleteAllNames_Umlas()
ExecuteExcel4Macro "SUM(DELETE.NAME(NAMES()))"
End Sub
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
dguillett1@austin.rr.com
"deacs" <deacs.23mzvm_1140621900.8214@excelforum-nospam.com> wrote in
message news:deacs.23mzvm_1140621900.8214@excelforum-nospam.com...
>
> I have different cells named through out a workbook in different tabs.
> Is it possible to delete all the named cells without going into each
> individual cell to delete the name? Thanks!
>
>
> --
> deacs
> ------------------------------------------------------------------------
> deacs's Profile:
> http://www.excelforum.com/member.php...fo&userid=2321
> View this thread: http://www.excelforum.com/showthread...hreadid=515343
>

Hi Don,

Thanks for your help. I do have a couple of questions though...
1) Will deleting the names from the cells create a problem with the formulas I have associated with those names? Basically, the worksheet is a financial statement model and most of the formulas were created with named cells and I would like to remove the names and just have the formulas point to the cell location instead of the name. Does your code accomplish this?

2) Can you point me to a quick dummy's how-to on how to implement your code in excel? Unfortunately, I am clueless when it comes to VBA.

Thanks again!