Run-time error '5981' - Could not open Macro Storage

[be17]

Does anybody know what this error message means. . . ."Run-time error '5981' - Could not Open Macro Storage"? I have a program in VBA set up for our employees so that they keep track of the amount of work that they do (they are secretaries). Each time they work on a document, they click on the program, which then automatically inserts the number of characters of that document into another page to be added up in order to calculate their incentive bonus. There are many different templates (in Word) that they use to do their work and one template in particular seems to be giving this error when they click on their incentive program that I have created. It has been working fine for months and then it just started to do this late last week. When I hit "debug", it brings me to the line of code that says "With ActiveDocument". Also, when I go to open up this actual template itself, it gives me the same error message. I do not know a lot about error handling so any help would be apprecitated. Thanks.

Bronwyn

 

[JohnYingling]

Go to

http://www.msdn.microsoft.com

and enter "Office error 5981" in the search box and press SEARCH. The first entry looks promising including the problem of multiple "Normal.Dot" files on a machine.

http://WWW.VBCompare.Com

 

[sureshtek]

You might have resolved it but may help somebody else.
Check the NAME of the Active document the template is trying to open it may have an 'illegal' character which VBA
doesn't like e.g '['.