Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Macro warning with no macros...

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello,

    I have a worksheet where I had macros at one time, but subsequently deleted them. With this worksheet, I still get a warning about macros whenever I open the sheet. Has anyone else had this problem? It's not a huge problem, but it is an annoyance, particularly when I distribute the sheet to others...

    Thanks,

    DanExcel

  2. #2
    Board Regular sen_edp's Avatar
    Join Date
    Mar 2002
    Location
    Hellas
    Posts
    555
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Did you remove the module that contained the macros? The presence of an
    empty module will trigger the macro warning. To remove a module, make sure
    the Project explorer window is open in the VB editor (View|Project
    Explorer), right click the module and choose "Remove Module".

  3. #3
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Why not just copy the sheets to a new workbook, delete old workbook , rename new one ?

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    sen_edp,

    Removing the module took care of it. Thank you.
    Thanks to Nimrod too for the suggestion.

    -DanExcel

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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