When you create a macro that contains the euro character (or any other European character) in the module, procedure, or macro name, you may receive the following error message:
Could not open macro storage.
↑ Back to the top
The euro character is one of many special characters that you cannot use to name modules, procedures, or project items. Other European and Asian characters may also cause the problem. This error also occurs if you have used a space, period (.), exclamation mark (!), or the character @, &, $, #, or [] in the module name.
↑ Back to the top
When you name your macro procedure, module, or macro, use standard alphanumeric characters from the English (U.S.) character set.
↑ Back to the top
For more information about Visual Basic for Applications naming rules, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type Visual Basic naming rules in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
↑ Back to the top