Macros keep coming up

  • Thread starter Thread starter deelish
  • Start date Start date
D

deelish

I think I've deleted all the macros from my file, but when I open th
file I still get the message that there are macros with the file.

Is there a way to ensure that all macros have been removed. I'v
already gone to Tools --> Macros and deleted the macros that wer
there. Can there be other Macros that don't exist there that could b
floating around in my file?

Thanks
 
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 for finding and removing code on the
following page, and a link to Chip Pearson's macro to remove all VBA
code in a workbook:

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