Mysterious macro(s)....
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Mysterious macro(s)....

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

    Default

     
    I'm sure this is pretty common but I'm not exactl sure what to search for. I copied a few sheets from an existing workbook that had macros into a NEW blank workbook. No cells or sheets are linked to the original file and everytime I open the new workbook, I'm prompted to "Enable or Disable macros..etc.." even though this new file doesn't seem to contain any VBA. I looked under Tools >> Macros and none are listed in the workbook. I even used the VBA toolbar and looked for any VBA modules or events that could be associated with this new file and nothing was found.

    Any ideas on how to get rid of this prompt?

    Thanks!

    (Excel 2000)

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have this problem with a lot of workbooks I get sent. There's no real code on the book, but usually some event subroutines somewhere.

    Follow these instructions, I hope they'll help

    1. Open Excel
    2. Press ALT+F11 to open the VBE
    3. In the VBA project window you'll see all of the sheetnames for the workbook listed there, plus one for "ThisWorkbook".
    4. Double click on the icon for the first sheet. If there is any text in the window that appears then delete it.
    5. Repeat step 4 for all of the sheets listed, plus "ThisWorkbook"

    HTH

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks. No luck. Every single sheet in the VBA editor had nothing associated with it nor did the WB.

    D'oh!


    Great forum by the way. Now if only one of these existed for that troublesome MS Word....

  4. #4
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    We have a resident Word expert. Dreamboat. You might want to check out her (and oz's) website.

    http://www.thewordexpert.com

    I believe that they have some tips and tricks there.



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
  •  

 

 
DMCA.com