I seem to have a ghost macro.

I set up a macro in Excel to do a simple copy and paste, then later deleted
it (half accidentally) not by using Delete in the Tools => Macros screen, but
by clearing all the steps in the Edit Macro screen.

Now the worksheet believes there's still a macro even though there isn't one
on the Tools => Macros screen. Any idea how to get rid of this "ghost"?

Thanks,
SongCoyote

When you record a macro, Excel creates a module in which the code is
stored. When you delete the macro, the module is not automatically
deleted. There are instructions here for finding and removing code:

http://www.contextures.com/xlfaqMac.html#NoMacros


SongCoyote wrote:
> I set up a macro in Excel to do a simple copy and paste, then later deleted
> it (half accidentally) not by using Delete in the Tools => Macros screen, but
> by clearing all the steps in the Edit Macro screen.
>
> Now the worksheet believes there's still a macro even though there isn't one
> on the Tools => Macros screen. Any idea how to get rid of this "ghost"?
>
> Thanks,
> SongCoyote


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html