Macro Enable/Disable Window

[sAYk]

Why does excel continues to display the "Disable Macros / Enable Macro" on
a workbook that had Macros, I've eliminated all Macros and the workbook but
still continues to show everytime I open the Excel File.

sAYk

 

[Harald Staff]

Hi

You must remove the modules themselves, not only their content.

 

[Debra Dalgleish]

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

 

[sAYk]

Found an Excellent Reference on the link you gave me, my problem has been
solve,

Thks Debra!