Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    macro warning... but no macro (2003)

    I have a SS and each time I open it I am presented with the macro warning window. When I look in macros, there are none. When I do Alt-F11 and double click on anything I can find, there is no evidence of any code.

    Why would Excel insist I have a macro in my SS?

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: macro warning... but no macro (2003)

    In the VB Editor, after Alt+F11, try Ctrl+R. There may be an empty Code Module. If so, try deleting it, saving the file & then re-opening. Hopefully, the Macro Warning will not come up. HTH
    Gre

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

    Re: macro warning... but no macro (2003)

    Also check the ThisWorkbook module and the code module associated with each sheet. You cannot delete these, but you can clear them if necessary.

  4. #4
    Star Lounger
    Join Date
    Apr 2002
    Location
    New York, New York, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: macro warning... but no macro (2003)

    I have to same problem, and neither of the two suggestions worked.

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

    Re: macro warning... but no macro (2003)

    If the workbook was originally created in an old version of Excel, it may contain an invisible macro sheet or dialog sheet. You can check this by typing (or copying) each of the following lines into the Immediate window in the Visual Basic Editor and pressing Enter. If one of them returns a number greater than 0, you have identified the culprit.

    ? ActiveWorkbook.Excel4MacroSheets.Count

    ? ActiveWorkbook.Excel4IntlMacroSheets.Count

    ? ActiveWorkbook.DialogSheets.Count

    It is also possible (but rare) that removing all code from a workbook fails to clear the warning. There's probably not much you can do about that, except reconstructing the workbook.

  6. #6
    Star Lounger
    Join Date
    Apr 2002
    Location
    New York, New York, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: macro warning... but no macro (2003)

    Thanks for the suggestion. I am using Excel '97, so that may explain the strange behavior.
    I simply copied the sheets to a new file and that solved the problem
    Michael Trombetta

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

    Re: macro warning... but no macro (2003)

    Ah yes, there were problems in Office 97 with macro warnings appearing even if there was no code present. Since the subject of the thread mentions 2003, I didn't know you were using 97. I'm glad you were able to solve the problem.

Posting Permissions

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