+ Reply to Thread
Results 1 to 4 of 4

4.0 Macro in Excel 2003

  1. #1
    Registered User
    Join Date
    08-16-2008
    Location
    Edmonton, Alberta, Canada
    Posts
    69

    4.0 Macro in Excel 2003

    Hello,

    I have a workbook that on opening I see the following message.

    This workbook contains one or more Microsoft Excel 4.0 macros.

    What's confusing is that I never downloaded any 4.0 macros. The ones that I have were either recorded or provided by this forum.

    I am trying to find this macro and delete it but I can't locate any 4.0 macros. I even copied all worksheets to a new workbook and when I go under Tools/Macro there are 0 displayed. I even launched the VB Editor and can't find any.

    It's not causing any problems even when I select Yes to enable these macros but it may cause some individuals to not want to open it which is a problem.

    I've also run Norton Antivirus and none were found. Additionally, if I open other workbooks this message is not displayed.

    Could someone have a look at the attached and see if they can identify what macro the message is referring to?

    Thanks and regards,
    Chris
    Attached Files Attached Files
    Last edited by NBVC; 10-08-2008 at 09:15 PM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello eckert1961,

    I just opened your file an no security message popped up. I am running Excel 2003 on Windows Xp.

    Sincerely,
    Leith Ross

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Look in defined names, e.g.,

    Sheets refers to: =SUBSTITUTE(GET.WORKBOOK(1),"["&GET.WORKBOOK(16)&"]","")&T(NOW())

    GET is an XLM4 macro.

  4. #4
    Registered User
    Join Date
    08-16-2008
    Location
    Edmonton, Alberta, Canada
    Posts
    69
    That did the trick Shg. Thanks for the quick response.

    Leith, I appreciate you taking the time to have a look.

    Regards,
    Chris

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Open another excel file while running macro
    By jai2808 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-04-2013, 12:42 AM
  2. Excel 2007 : Macro 2003 crashes in 2007
    By Fun4You in forum Excel General
    Replies: 0
    Last Post: 06-09-2008, 09:53 AM
  3. Bug in Excel 2003 Application.Run with dashes in filenames
    By ctmurray in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-21-2007, 08:00 PM
  4. Macro between Word and Excel
    By ChemistB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2007, 08:03 PM
  5. Excel 2003 Web Query Error - "strict parse error"
    By spdoher in forum Excel General
    Replies: 0
    Last Post: 12-01-2006, 03:48 PM

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