Runtime Error 5981 Could not open Macro Storage error.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

steve - 14 Nov 2007 15:05 GMT

I am getting the following error "Runtime Error 5981 Could not open
Macro Storage"
I'm running an Autoexec in the Word startup folder ( in a .dot file).
I have another .dot in the Startup, it runs fine with no errors. It is
in all likelihood I think it is a permission issue. We are on domain
with active directories. When I log on as administrator it works. I
have put this .dot on other peoples computers who are not
administrators and it works no error. The other bit of information
that I think is important is that when I try to copy a Macro's, using
\Tools\Templates and Add-In's .. from a custom .dot to the nomal.dot ,
left had window to right hand window with has the normal.dot it will
not let me. The macros will not copy. Like there is some permission
that is preventing me. I have read MS Support articles relating to
this issue, but nothing helps.
I really think the inability to copy macros is key, anybody know how
to resolve this or any of these issues.

Thanks.

Reply to this Message

Shauna Kelly - 14 Nov 2007 23:22 GMT

Hi Steve

There are several possible causes of a 5981 error, but the most frequent in
my experience is a broken reference. Your task will be to track down which
of your files has the broken reference.

To do that, do Tools > Templates and Addin-ins and un-load all addins
(global templates) listed in that dialog box.

Now, use File > Open to open each of the .dot files in your startup folder.

Use Alt-F11 to open the VBE. In the project explorer, click on each of your
open files in turn. For each file, do Tools > References. If you find a
broken reference, you'll need to un-tick that reference, close the dialog
box, re-open Tools > References and set the reference to the correct source.
Then save that file.

The best way to copy macros from one file to another is to use the VBE.
Using the Organizer, you can only copy some things, and only a whole module
at a time. But to work with a file that is loaded as an add-in, you must
first un-load it, and then use File > Open to open it.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word

>I am getting the following error "Runtime Error 5981 Could not open
> Macro Storage"
[quoted text clipped - 14 lines]
>
> Thanks.

Reply to this Message

steve - 15 Nov 2007 11:39 GMT

Thank you for your answer. I will have to carfully look it over. I saw
a few notes on this in my searching but didnt quite understand it. I
will try to work through the steps you have provided.

Can you tell me if this answer you have provided is still true, in my
case where it works for the Administrator on machine X but not for a
User on machine X. Do the References changed based on who is logged on
to the computer?

Thanks

Reply to this Message