Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Marco or not (Excel97)

    A coworker has discovered an apparent glitch in a worksheet. When he opens the sheet, the "Enable/Disable Macros" dialog box appears, but there are no macros in the sheet. A named range "_0" or "_O" appeared but was deleted. The file was saved and reopened, but still, the worksheet thinks its got a macro. There are no hidden sheetsor files and we checked to see if other files were open (there were none). The file has been used for several months, but this message only began to appear this week. Our network scans for viruses so we don't think that is a problem, and the user rarely installs from or uses a floppy disk or CD.
    Can anyone offer an insight as to what might be happening and how we might correct and prevent this from recurring?

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

    Re: Marco or not (Excel97)

    Check if there are no (empty) modules in the VBAproject of this workbook. Maybe, this is accidentely inserted? Remove it if there is one, and you should not receive the enable/disable message anymore. Hope this helps.

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Marco or not (Excel97)

    An empty macro module is enough to generate the "Enable/Disable" macros dialog. With the file open, go to the VB editor (Alt-F11) and check for any modules in the Project explorer (the window on the left side). Make sure the modules are empty and delete them.

    Andrew C

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Marco or not (Excel97)

    Thanks to all for your helpful and timely replies. There are no macros displayed from Tools-Macros, but there is some code in VB Editor. We're trying to figure out who may have put it there and what its intended to do. Chances are we can just delete it, but must first research.

  5. #5
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Marco or not (Excel97)

    my advice is to post the file here if non-sensitive - someone will soon tell you whether there is any code and if so, what it's for. Or if the file is sensitive, just post the code you said you see in the VBE.

    Brooke

Posting Permissions

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