VBA Excel: The macro can not be executed.

If an error message such as:

Das Makro 'foo.xls!makro1' kann nicht ausgeführt werden. Das Makro ist möglicherweise in dieser Arbietsmappe nicht verfügbar, oder alle Makros wurden deaktiviert.

You should first check the security settings for macros, and then check, whether the macro is stored in a separate module and not in the workbook.

Maybe also interesting for MS Excel macro expert: The macro speed up Guide

  1. The note does not help, If the error message when the program, Although everything was ok before. Only help so far: Excel stop and restart.
    Does anyone have a better tip?

  2. Thanks for the hint, had mail from someone else to work over and got me ' looking for a Wolf ;) . Macros and module and voila funzt.