Make sure that your sheet is not protected,
Select the 'Data' tab then 'edit links' then break the offending links.

"Trevor W" wrote:

First, I have no idea how a reference to a macro got installed. I copied a
block of cells from one spreadsheet and pasted into another using paste
special: values.

I almost immediately made a mistake and typed ctrl-z to undo the mistake. I
then get n error that a macro is missing. I look in the Macro manager and two
references to two macros are listed and the original worksheet is from the
spreadsheet where I just copied a small block of data.

My problem: When I highlight the macros, the delete button is greyed-out - I
cannot delete or edit them. My ctrl-z is locked up to these bogus macros.

I am using Office (Excel) 2007 Professional

PLEASE - What do I do?

Who is the %^@* (sorry - I am mad) that programmed this and turned off the
delete button or at least didn't create a delete reference button.