+ Reply to Thread
Results 1 to 5 of 5

ghost macro

  1. #1
    gevans
    Guest

    ghost macro

    I have a very large spreadsheet that gets copied every month as a new
    template. Somewhere along the line it has aquired a "ghost" macro. It
    causes the "macro alert" warning to come up everytime the spreadsheet is
    opened. Under the menu item for macros, there are none listed for this
    spreadsheet. There are no links to outside sheets. How do I find and delete
    the ghost macros?
    --
    gevans

  2. #2
    Dave Peterson
    Guest

    Re: ghost macro

    Debra Dalgleish shows how to clean up all the remnants of macros:
    http://www.contextures.com/xlfaqMac.html#NoMacros

    gevans wrote:
    >
    > I have a very large spreadsheet that gets copied every month as a new
    > template. Somewhere along the line it has aquired a "ghost" macro. It
    > causes the "macro alert" warning to come up everytime the spreadsheet is
    > opened. Under the menu item for macros, there are none listed for this
    > spreadsheet. There are no links to outside sheets. How do I find and delete
    > the ghost macros?
    > --
    > gevans


    --

    Dave Peterson

  3. #3
    DaveO
    Guest

    RE: ghost macro

    Hit Alt+F11 and this will open the VBE.

    Now all you need to do it go through all of the worksheets and the
    'ThisWorkbook' you have to see if there are any events.

    If not check to see if there are any modules in the sheet.

    If not, my only advise would be to see if you have a macro in the sheet
    which you are opening when you simply open excel.

    HTH.

    "gevans" wrote:

    > I have a very large spreadsheet that gets copied every month as a new
    > template. Somewhere along the line it has aquired a "ghost" macro. It
    > causes the "macro alert" warning to come up everytime the spreadsheet is
    > opened. Under the menu item for macros, there are none listed for this
    > spreadsheet. There are no links to outside sheets. How do I find and delete
    > the ghost macros?
    > --
    > gevans


  4. #4
    gevans
    Guest

    RE: ghost macro

    I opened VBE. I'm not sure I know where to look for "events" or "modules", I
    am not familiar with the VBE function.
    It is possible that a macro opens with Excel, but this is the only
    spreadsheet that gives me the warning, so I'm thinking the problem is limited
    to this spreadsheet.
    --
    gevans


    "DaveO" wrote:

    > Hit Alt+F11 and this will open the VBE.
    >
    > Now all you need to do it go through all of the worksheets and the
    > 'ThisWorkbook' you have to see if there are any events.
    >
    > If not check to see if there are any modules in the sheet.
    >
    > If not, my only advise would be to see if you have a macro in the sheet
    > which you are opening when you simply open excel.
    >
    > HTH.
    >
    > "gevans" wrote:
    >
    > > I have a very large spreadsheet that gets copied every month as a new
    > > template. Somewhere along the line it has aquired a "ghost" macro. It
    > > causes the "macro alert" warning to come up everytime the spreadsheet is
    > > opened. Under the menu item for macros, there are none listed for this
    > > spreadsheet. There are no links to outside sheets. How do I find and delete
    > > the ghost macros?
    > > --
    > > gevans


  5. #5
    gevans
    Guest

    Re: ghost macro

    Thank you Dave! Just what I needed!!! Deleting the module 1 and module 2
    files did the trick. We have put up with this annoying function for 2 years.
    Bossman will be happy!
    --
    gevans


    "Dave Peterson" wrote:

    > Debra Dalgleish shows how to clean up all the remnants of macros:
    > http://www.contextures.com/xlfaqMac.html#NoMacros
    >
    > gevans wrote:
    > >
    > > I have a very large spreadsheet that gets copied every month as a new
    > > template. Somewhere along the line it has aquired a "ghost" macro. It
    > > causes the "macro alert" warning to come up everytime the spreadsheet is
    > > opened. Under the menu item for macros, there are none listed for this
    > > spreadsheet. There are no links to outside sheets. How do I find and delete
    > > the ghost macros?
    > > --
    > > gevans

    >
    > --
    >
    > Dave Peterson
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1