Results 1 to 3 of 3
  1. #1
    robjd
    Guest

    Removing Macros from spreadsheet

    Hello

    I have a workbook that, when opened, asks whether the macros should be disabled. We have never created a macro on this worksheet but an Inoculate anti virus scan comes out clean. When I open it with macros enabled and go to Tools - Macro -Macros nothing is listed. How can I find the Macro that it is referring to? This workbook needs to be sent to someone else and I would really like to fix this before sending it out.

    I am working in Excel 97 on a NT4 workstation.

    Thanks
    Rob

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Removing Macros from spreadsheet

    Just go to the Visual Basic editor (via tools > Macro > Visual Basic Editor) and see if a general module is present in your VBAproject (to see this, select View > Project Explorer). If so, even empty, you will get the macro warning message. Remove the module if empty and you will no longer get the macro warning message. Hope this helps.

  3. #3
    robjd
    Guest

    Re: Removing Macros from spreadsheet

    Thanks for the quick reply.

    I found a little procedure attached to one of the pages that I removed. No more message!!!!! Thanks.

Posting Permissions

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