SOLVED

Funktionen mit xlm-Makros werden blockiert

%3CLINGO-SUB%20id%3D%22lingo-sub-2981213%22%20slang%3D%22de-DE%22%3EFunctions%20with%20xlm%20macros%20are%20blocked%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2981213%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%20Community%2C%3C%2FP%3E%3CP%3Ewe%20have%20a%20customer%20who%20still%20works%20with%20old%20Excel%20macros.%20Until%20recently%2C%20everything%20worked%20fine.%20For%20a%20few%20days%20now%2C%20some%20employees%20have%20been%20reporting%20that%20the%20macros%20are%20no%20longer%20working%20and%20that%20an%20error%20message%20with%20the%20message%20%22Functions%20with%20xlm%20macros%20are%20blocked%22%20is%20displayed%20in%20the%20cells.%20What%20can%20we%20do%3F%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3CP%3EStefan%3C%2FP%3E%3CP%3E---%3C%2FP%3E%3CPRE%3E%3CSPAN%20class%3D%22%22%3EHello%20Community%2C%0A%0Awe%20have%20a%20customer%20who%20still%20works%20with%20old%20Excel%20macros.%20Everything%20worked%20fine%20until%20recently.%20For%20a%20few%20days%2C%20some%20employees%20have%20reported%20that%20the%20macros%20no%20longer%20work%20and%20an%20error%20message%20is%20displayed%20in%20the%20cells%20with%20the%20message%20%22Functions%20with%20xlm%20macros%20are%20blocked%22.%20What%20can%20we%20do%3F%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2981213%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2981361%22%20slang%3D%22en-US%22%3ERe%3A%20Funktionen%20mit%20xlm-Makros%20werden%20blockiert%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2981361%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1222959%22%20target%3D%22_blank%22%3E%40Stefan1500%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Edas%20h%C3%A4ngt%20h%C3%B6chstwahrscheinlich%20mit%20einer%20neuen%20Sicherheitseinstellung%20zusammen%2C%20die%20Microsoft%20ausrollt%2C%20um%20Excel%204.0-Makros%20standardm%C3%A4%C3%9Fig%20zu%20deaktivieren.%3C%2FP%3E%3CP%3EMan%20kann%20das%20bei%20Bedarf%20im%20Trustcenter%20abschalten%3A%3C%2FP%3E%3CP%3EMen%C3%BC%20%22Datei%20%7C%20Optionen%20%7C%20Trust%20Center%20%7C%20Einstellungen%20f%C3%BCr%20das%20Trust%20Center...%22.%3C%2FP%3E%3CP%3EDort%20d%C3%BCrfte%20es%20irgendwo%20unter%20Makroeinstellungen%2C%26nbsp%3B%20Gesch%C3%BCtzte%20Ansicht%20oder%20Zugriffsschutzeinstellungen%20zu%20finden%20sein.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2981364%22%20slang%3D%22en-US%22%3ERe%3A%20Funktionen%20mit%20xlm-Makros%20werden%20blockiert%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2981364%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1222959%22%20target%3D%22_blank%22%3E%40Stefan1500%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20File%20%26gt%3B%20Options%20%26gt%3B%20Trust%20Center%20%26gt%3B%20Trust%20Center%20Settings...%20%26gt%3B%20Macro%20Settings...%3C%2FP%3E%0A%3CP%3ETick%20the%20check%20box%20%22Enable%20Excel%204.0%20Macros%20when%20VBA%20macros%20are%20enabled%22.%3C%2FP%3E%0A%3CP%3EClick%20OK.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0895.png%22%20style%3D%22width%3A%20644px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F328038i1A67DD0D7BC8C1B4%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S0895.png%22%20alt%3D%22S0895.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hallo Community,

wir haben einen Kunden welcher noch mit alten Excel Makros arbeitet. Bis vor kurzem funktionierte alles gut. Seit einigen Tagen berichten einige Mitarbeiter, dass die Makros nicht mehr funktonieren und in den Zellen eine Fehlermeldung mit dem Hinweis "Funktionen mit xlm-Makros werden blockiert" angezeigt wird. Was können wir tun?

Beste Grüße

Stefan

---

Hello Community,

we have a customer who still works with old Excel macros. Everything worked fine until recently. For a few days, some employees have reported that the macros no longer work and an error message is displayed in the cells with the message "Functions with xlm macros are blocked". What can we do?
5 Replies

Hi @Stefan1500,

 

das hängt höchstwahrscheinlich mit einer neuen Sicherheitseinstellung zusammen, die Microsoft ausrollt, um Excel 4.0-Makros standardmäßig zu deaktivieren.

Man kann das bei Bedarf im Trustcenter abschalten:

Menü "Datei | Optionen | Trust Center | Einstellungen für das Trust Center...".

Dort dürfte es irgendwo unter Makroeinstellungen,  Geschützte Ansicht oder Zugriffsschutzeinstellungen zu finden sein.

best response confirmed by Stefan1500 (Occasional Contributor)
Solution

@Stefan1500 

Select File > Options > Trust Center > Trust Center Settings... > Macro Settings...

Tick the check box "Enable Excel 4.0 Macros when VBA macros are enabled".

Click OK.

S0895.png

Hi @DTE,
ah ja, sowas dachte ich mir schon. Habe aber diese Einstellung nicht gefunden ;-). Werde es mal checken.
Danke,
Stefan

Hallo @DTE,

 

das wars in der Tat. Problem gelöst! Vielen Dank!

 

VG

Stefan 

Hallo @Hans Vogelaar,

das wars in der Tat. Problem gelöst! Vielen Dank!

VG
Stefan