Open up the VB editor and remove the module.


>Hi,
>
>Have to put in VB code in Excel to clean up some reports. No problem.
>
>Problem is how do I take out my codes so that Excel won't pop up the ugly message about Macro in my sheet? (the prompt with 2 buttons, "Disable Macro", "Enable Macro" and "More Info")
>
>I have deleted the button control which I added on worksheet, as well as the codes in VB Editor. But the prompt still comes up ever time someone opens the file.
>
>Thanks,
>~Sheldon