none
excel visual basic debug error RRS feed

  • Question

  • Hi, I am using excel 2003, on XP and when I go to close an excel document within excel, not closing the program, just the sheet that is there and then to go open another - I get a visual basic error - "runtime error 424 object required" then below that it has debug, close, help. Whether you choose file then close, or use the keyboard shortcut to close the active sheet, it gives the same error. Thank you for anyones help!! Oh I and I have sp3 on both office and xp, and update always.
    Wednesday, July 7, 2010 8:45 PM

Answers

  • This means that there is an error in one of the macros.

    If this error only occurs when a single workbook is open, then there's a good
    chance that the error is in the code in that workbook's project.

    If you're not the developer of the macro, then go back to that developer and
    explain what's happening.

    If the error occurs at various times and you can't really isolate the problem,
    then you'll have some detective work to do.

    Chip Pearson has some notes on how to diagnose errors:
    http://www.cpearson.com/excel/StartupErrors.htm

    And Jan Karel Pieterse has more notes:
    http://www.jkp-ads.com/Articles/StartupProblems.asp

    Essentially, you'll turn off all the addins/startup workbooks and then open
    excel.  And then turn on each addin (closing and reopening) one at a time to
    find the culprit.

    dtdave wrote:


    Hi, I am using excel 2003, on XP and when I go to close an excel document within excel, not closing the program, just the sheet that is there and then to go open another - I get a visual basic error - "runtime error 424 object required" then below that it has debug, close, help. Whether you choose file then close, or use the keyboard shortcut to close the active sheet, it gives the same error. Thank you for anyones help!! Oh I and I have sp3 on both office and xp, and update always.

    --

    Dave Peterson

    Wednesday, July 7, 2010 9:09 PM

All replies

  • This means that there is an error in one of the macros.

    If this error only occurs when a single workbook is open, then there's a good
    chance that the error is in the code in that workbook's project.

    If you're not the developer of the macro, then go back to that developer and
    explain what's happening.

    If the error occurs at various times and you can't really isolate the problem,
    then you'll have some detective work to do.

    Chip Pearson has some notes on how to diagnose errors:
    http://www.cpearson.com/excel/StartupErrors.htm

    And Jan Karel Pieterse has more notes:
    http://www.jkp-ads.com/Articles/StartupProblems.asp

    Essentially, you'll turn off all the addins/startup workbooks and then open
    excel.  And then turn on each addin (closing and reopening) one at a time to
    find the culprit.

    dtdave wrote:


    Hi, I am using excel 2003, on XP and when I go to close an excel document within excel, not closing the program, just the sheet that is there and then to go open another - I get a visual basic error - "runtime error 424 object required" then below that it has debug, close, help. Whether you choose file then close, or use the keyboard shortcut to close the active sheet, it gives the same error. Thank you for anyones help!! Oh I and I have sp3 on both office and xp, and update always.

    --

    Dave Peterson

    Wednesday, July 7, 2010 9:09 PM
  • thanks I will give it a try
    Thursday, July 8, 2010 10:51 PM