quick names removal before sheet move

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jose Mourinho - 26 Mar 2008 13:30 GMT

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

Reply to this Message

Don Guillett - 26 Mar 2008 13:40 GMT

Example layout along with example of data and name list

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

>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.
[quoted text clipped - 6 lines]
>
> JM

Reply to this Message

Gary''s Student - 26 Mar 2008 13:52 GMT

Try this little macro:

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

Signature

Gary''s Student - gsnu200775

> 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.
[quoted text clipped - 5 lines]
>
> JM

Reply to this Message

Don Guillett - 26 Mar 2008 14:33 GMT

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

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> Try this little macro:
>
[quoted text clipped - 16 lines]
>>
>> JM

Reply to this Message