• runtime error 5981 (97 SR-1)

    Home » Forums » AskWoody support » Productivity software by function » MS Word and word processing help » runtime error 5981 (97 SR-1)

    Author
    Topic
    WSnblair
    AskWoody Lounger
    December 18, 2003 at 7:13 pm #398182

    I m getting an error message: runtime error 5981. Could not open macro storage. Doc does contain macros from a known/trusted source. The only thing I could find in the MS KB said to remane normal.dot, and try opening the file again. No luck. Any help would be appreciated…Neil

    Reply | Quote
    Viewing 5 reply threads
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      December 18, 2003 at 7:34 pm #759295

      Another thing to try is to re-install VBE.DLL. You need to have your Office 97 CD-ROM available for this. See the third method in OFF97: Errors Starting Visual Basic Editor.

      You can also try the steps outlined in Systematic Approach to Behavioral Problems in Word (97/2000).

      Reply | Quote
    • WSHansV
      AskWoody Lounger
      December 18, 2003 at 7:34 pm #759296

      Another thing to try is to re-install VBE.DLL. You need to have your Office 97 CD-ROM available for this. See the third method in OFF97: Errors Starting Visual Basic Editor.

      You can also try the steps outlined in Systematic Approach to Behavioral Problems in Word (97/2000).

      Reply | Quote
    • WSjscher2000
      AskWoody Lounger
      December 18, 2003 at 9:49 pm #759340

      Another thing that can cause this error: When one sets up a VBA project in a document or template, it will automatically refer to certain external files that come with MS Office. However, the programmer can add references to other files, for example, a file that stores controls (like a drop-down calendar that lets you pick dates) or a file that contains functions for working with database files. If a referenced file does not exist on your computer, then you can get this (unhelpful) error. If no other technique works to open this file, ask the sender to remove all references other than the standard ones (Office, Word, VBA, and OLE) and see if that helps.

      Reply | Quote
    • WSjscher2000
      AskWoody Lounger
      December 18, 2003 at 9:49 pm #759341

      Another thing that can cause this error: When one sets up a VBA project in a document or template, it will automatically refer to certain external files that come with MS Office. However, the programmer can add references to other files, for example, a file that stores controls (like a drop-down calendar that lets you pick dates) or a file that contains functions for working with database files. If a referenced file does not exist on your computer, then you can get this (unhelpful) error. If no other technique works to open this file, ask the sender to remove all references other than the standard ones (Office, Word, VBA, and OLE) and see if that helps.

      Reply | Quote
    • WSJanB
      AskWoody Lounger
      December 19, 2003 at 1:21 pm #759545

      I encountered the same error when opening a file with a (ore more) Sub/Function with the same name as a Sub/Function in a add-in. Temporarily de-installing the add-in and renaming the offending Sub/Function cured the problem.

      Jan

      Reply | Quote
    • WSJanB
      AskWoody Lounger
      December 19, 2003 at 1:21 pm #759546

      I encountered the same error when opening a file with a (ore more) Sub/Function with the same name as a Sub/Function in a add-in. Temporarily de-installing the add-in and renaming the offending Sub/Function cured the problem.

      Jan

      Reply | Quote
    Viewing 5 reply threads
    Reply To: runtime error 5981 (97 SR-1)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    March 2025
    S M T W T F S
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.