Formulas Ribbon with clearing Name Manager 1

[UnsolvedCoding]

This is a new one for me and something that was just discovered with our main workbook.

Worksheets will sometimes get copied over to the main workbook. However this can create names in the name manager and recording a macro didn't offer any light on how to remove all the names. Since I don't know the names, and can't know the names because they are based on future job numbers its a problem.

What code is there that would remove all the names from the name manager so we don't link to workbooks that are of no relevance?

It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and questions about Raid.
Therefore I have come to the logical conclusion that the only way to have a properly functioning computer is to regularly spray it with Raid bug killer.

 

[SkipVought]

Hi,

[pre]
Dim nm As Name, ws As Worksheet

For Each nm in ActiveWorkbook.Names
nm.Delete
Next

For each ws in ActiveWorkbook.Worksheets
For Each nm in ws.Names
nm.Delete
Next
Next

[/pre]

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[UnsolvedCoding]

Thanks Skip!

It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and questions about Raid.
Therefore I have come to the logical conclusion that the only way to have a properly functioning computer is to regularly spray it with Raid bug killer.

 

[SkipVought]

I just called you a name, but my procedure deleted it

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]