quick names removal before sheet move
 

I regularly copy a particular sheet over to another workbook, but have to
click away a multitude of Names in that sheet when prompted by Excel (i.e.
whether to copy the names over to the new workbook or not). Is not my sheet,
so cannot have the Names permanantly removed unfortunately. Is a tedious
process...I would love to have a 'Ignore all' button (maybe one day eh?).

Anyone know a quick way to avoid all this clicking?

JM

quick names removal before sheet move
 

Example layout along with example of data and name list

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jose Mourinho" wrote in message
...
I regularly copy a particular sheet over to another workbook, but have to
click away a multitude of Names in that sheet when prompted by Excel (i.e.
whether to copy the names over to the new workbook or not). Is not my
sheet,
so cannot have the Names permanantly removed unfortunately. Is a tedious
process...I would love to have a 'Ignore all' button (maybe one day eh?).

Anyone know a quick way to avoid all this clicking?

JM

quick names removal before sheet move
 

Try this little macro:

Sub NameDropper()
n = ActiveWorkbook.Names.Count
For i = n To 1 Step -1
ActiveWorkbook.Names(i).Delete
Next
End Sub

--
Gary''s Student - gsnu200775


"Jose Mourinho" wrote:

I regularly copy a particular sheet over to another workbook, but have to
click away a multitude of Names in that sheet when prompted by Excel (i.e.
whether to copy the names over to the new workbook or not). Is not my sheet,
so cannot have the Names permanantly removed unfortunately. Is a tedious
process...I would love to have a 'Ignore all' button (maybe one day eh?).

Anyone know a quick way to avoid all this clicking?

JM

quick names removal before sheet move
 

If you guessed correctly that OP wants to remove "names" then this will also
work

for each n in activeworkbook.names
n.delete
next n

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gary''s Student" wrote in message
...
Try this little macro:

Sub NameDropper()
n = ActiveWorkbook.Names.Count
For i = n To 1 Step -1
ActiveWorkbook.Names(i).Delete
Next
End Sub

--
Gary''s Student - gsnu200775


"Jose Mourinho" wrote:

I regularly copy a particular sheet over to another workbook, but have to
click away a multitude of Names in that sheet when prompted by Excel
(i.e.
whether to copy the names over to the new workbook or not). Is not my
sheet,
so cannot have the Names permanantly removed unfortunately. Is a tedious
process...I would love to have a 'Ignore all' button (maybe one day eh?).

Anyone know a quick way to avoid all this clicking?

JM