Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: workbook contains macros or does it?

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    232
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    I've been sent a workbook, that when you open it, asks to disable macros etc.

    When going into the VBE I find no code/modules etc.... it's a simple worksheet with a few SUM()

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-11 03:18, mrowe wrote:
    Hi,

    I've been sent a workbook, that when you open it, asks to disable macros etc.

    When going into the VBE I find no code/modules etc.... it's a simple worksheet with a few SUM()
    Check the worksheets for any code.
    ie while in VBE explorer double click
    on the sheet code name and check for any code here.




    Kind Regards,
    Ivan F Moala From the City of Sails

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    St. Louis
    Posts
    71
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have similar problems. See my question posted today "MYSTERIOUS FILE.....

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    232
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I only looked for modules, as I thought all code would live in here (my mistake). There was one sheet with a private sub() in it...

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
  •