Excel Phantom Macro annoying me!

5 pts.
Tags:
Excel macros
Security
Hi. I have a workbook that *did* contain some simple macros. However I no longer needed them so deleted them, but now when I open the excel workbook it still comes up with the "enable/disable macro" dialog box.... I have no macros in existence so how do I stop the security warning appearing every time I open the file? I am not a techno-geek so appreciate any answers in plain english!! Thanks =)
ASKED: September 24, 2008  11:55 PM
UPDATED: September 25, 2008  3:10 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

A macro has been added and then removed, leaving an empty module. Empty modules trigger the macro query, as does an actual macro.

1. Warning: As a precaution, you should make a backup copy of the file, before you remove any code.
2. Right click on any sheet tab and choose View Code, to open the Visual Basic Editor.
3. In the Project Explorer at the left of the screen, find the workbook. In the sample shown here, Book4 is the workbook name — VBAProject (Book4)
4. Look for a Modules folder, and open it. (If there is no Modules folder, go to Step 6.)
5. For each module in the folder:
1. Right-click on the module name.
2. Choose Remove Module1 (the name of your module may be different)
3. Click No when asked if you want to Export.
6. Open the Microsoft Excel Objects folder.
7. For each worksheet, and for This Workbook:
1. Double-click on the object name, to open its code module. In this sample, you’d double-click on Sheet1
2. On the keyboard, press Ctrl+A to select all the code (even if the code module looks empty)
3. Press the Delete key.

8. Look for a Forms folder, and open it.
9. Delete any UserForms that it contains.
10. Look for a Class Modules folder, and open it.
11. Delete any class modules that it contains.

12. Close the Visual Basic Editor.
13. Save the changes to the workbook.

A macro to remove all VBA code in a workbook is available at Chip Pearson’s web site:

<a href=” http://www.cpearson.com/excel/vbe.htm “> http://www.cpearson.com/excel/vbe.htm </a>

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Robert Stewart
    I believe if you open up your excel worksheet, then left click on Tools, then left click on Macros, then change the security setting to low of course read all the issues and concerns that can happen if you do this. This should at least stop the annoying dialog box asking you disable or cancel. I hope this helps and is what you are looking for. Again though be aware of the security concerns regarding this.
    1,810 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following