How to delete a macro that has been assigned to run when workshee.
 

There are macros that have been programmed into a worksheet that I copied.
These macros are assigned to start-up when I open the worksheet. I then
received a warning message that the macro cannot find the file that it has
been assigned to access at start-up. I do not need the macro and would like
to delete it, however, when I click on the macro it tells me the the
reference is invalid. The delete key for this macor is not highlighted which
prevents me from deleting it from my worksheet.

Any help would be sincerely appreciated.

Go into the VBE, and look in the codemodule of the ThisWorkbook object, and
also look in any sheet modules as well. If an event was used, you can't get
to it through the usual Macro edit technique.

HTH,
Bernie
MS Excel MVP

"tcsigecan" wrote in message
...
There are macros that have been programmed into a worksheet that I copied.
These macros are assigned to start-up when I open the worksheet. I then
received a warning message that the macro cannot find the file that it has
been assigned to access at start-up. I do not need the macro and would
like
to delete it, however, when I click on the macro it tells me the the
reference is invalid. The delete key for this macor is not highlighted
which
prevents me from deleting it from my worksheet.

Any help would be sincerely appreciated.