I have a workbook that was created using an older file as the starting point.
Somewhere along the way information was deleting leaving behind defined
names and macros.

I have tried to delete these old macros but the delete button is grayed out
when I pull up the macro. If I try and edit the macro, I get a reference is
not valid message. These macros are often assigned to shortcut keys I
normally use, like control R or Control Y, so I must select via the menu or a
shortcut key on my tool bar.

When I copy a sheet mulitple times, I will get a message that the name
already exists in the destination worksheet. I have tried deleting defined
names, but it does not seem to get rid of the problem. I do not seem to find
the name that causes the message. I just have to select yes for each of the
names and then the sheet copies.

I can still use the workbook, it is just annoying to have to deal with these
old items each time. Any suggestions on how to eliminate these issues?