Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Norwich, Connecticut, USA
    Posts
    150
    Thanks
    14
    Thanked 0 Times in 0 Posts

    Kill Macro Warning (Excel 2003 SP2)

    I have a worksheet in which I created two macros. I no longer need them and have deleted them. However, I still get get a security warning window when I open the worksheet that says the worksheet contains macros and I can choose to either enable or disable them, even though there are no longer any macros in the worksheet. How can I get rid of that security warning? My security setting is set at Medium and it has never been changed, either before or after I created / deleted the macros.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Kill Macro Warning (Excel 2003 SP2)

    Have you deleted the module that contained the macros? As long as the module remains, Excel will display the macro warning. To check:
    - Open the workbook.
    - Press Alt+F11 to activate the Visual Basic Editor.
    - Look for the workbook in the Project Explorer on the left hand side.
    - If there is a Modules node under it, expand it (if necessary).
    - Right-click the module and select the option to remove it from the popup menu.
    - There is no need to export the module before removing it, so click No in the prompt that appears.
    - Repeat if there are more modules.
    - Note: you cannot remove ThisWorkbook and the worksheet modules under Microsoft Excel Objects.
    - Switch back to Excel.
    - Save and close the workbook.

    Post back if that doesn't help.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Norwich, Connecticut, USA
    Posts
    150
    Thanks
    14
    Thanked 0 Times in 0 Posts

    Re: Kill Macro Warning (Excel 2003 SP2)

    Hans,
    Worked great! Thank you very much!
    Robert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •