MS Excel 2000 - Possible macro corruption! HELP!!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • boliches
    New Member
    • Feb 2007
    • 62

    #1

    MS Excel 2000 - Possible macro corruption! HELP!!

    I have been building a comprehensive spread sheet in MS Excel 2000, with numerous pages. Everything went well (using VB) and the task was complete. To enhance the users input I added a "Menu" page with macros (command buttons) to take the user to various pages. Great all going well! Until... All of a sudden a MS Message

    "Microsoft Excel for Windows has encountered a problem and needs to close. We are sorry for the inconvenience."

    Now I cannot enter the program - can anyone help me as I need a back door to delete the "Menu" page as I believe this may be the cause of the problem.
  • ubentook
    New Member
    • Dec 2007
    • 58

    #2
    Try opening the file with Macros disabled.


    Originally posted by boliches
    I have been building a comprehensive spread sheet in MS Excel 2000, with numerous pages. Everything went well (using VB) and the task was complete. To enhance the users input I added a "Menu" page with macros (command buttons) to take the user to various pages. Great all going well! Until... All of a sudden a MS Message

    "Microsoft Excel for Windows has encountered a problem and needs to close. We are sorry for the inconvenience."

    Now I cannot enter the program - can anyone help me as I need a back door to delete the "Menu" page as I believe this may be the cause of the problem.

    Comment

    • boliches
      New Member
      • Feb 2007
      • 62

      #3
      I dont get the option! As soon as I try to open the file the Microsoft Message is dispalyed and then the whole of MS Excel closes! I have tried opening via Open Office with not much luck as it only allows 1 sheet to be imported and then there is no VB access that I can find.
      If I could get at my code in Visual Basic I could recreate everything else. But I just dont how to get there! If I go to the VB editor in a fresh page I cannot access the code I want as I still need to open my problem file.

      ANY IDEAS??

      Comment

      • boliches
        New Member
        • Feb 2007
        • 62

        #4
        Mission accomplished! Microsoft Office 2007 has solved the problem

        Comment

        Working...