With Excel, all buttons don't activate macros

Question

With Excel, all buttons don't activate macros

Anonyme

Tous les fichiers excel existant sur mon PC comportant des macros ont le même problème: les boutons n'activent plus les macros (qui sont par ailleurs fonctionnelles). Par contre, quand je crée un nouveau fichier excel, tout fonctionne correctement.
Que faire

All existing Excel Files on my personnal computer have now the same problem: Buttons don't activate macros (but macros are effective).

When I create a new file, I can create macro and buttons, and everything is correct.

Could you tell me how I can resolve this problem?

Sincerely

Excuse me for my poor English language, I am French

Question verrouillée. Cette question a été migrée à partir de la Communauté Support Microsoft. Vous pouvez voter pour indiquer si elle est utile, mais vous ne pouvez pas ajouter de commentaires ou de réponses ni suivre la question.

0 commentaires

1 réponse

Answer 1

Hello,

Thanks for posting in the Microsoft community.

I understand that in your existing Excel files, the buttons no longer activate the macros, even though the macros themselves still work. However, when you create a new Excel file, everything functions correctly. This issue is likely related to Excel’s security settings or file trust configuration.

Here are a few steps you can try to resolve the issue:

Check Macro Settings:

>> Open Excel and go to File > Options > Trust Center > Trust Center Settings > Macro Settings.

>> Select “Enable all macros” (for testing only—please revert to a safer setting afterward).

Add Trusted Locations:

>> In the Trust Center, go to Trusted Locations.

>> Add the folder where your Excel files are saved.

Unblock the Files:

>> Right-click on one of the affected Excel files in File Explorer.

>> Choose Properties.

>> If you see an “Unblock” checkbox at the bottom, check it and click OK.

Reassign the Macros to the Buttons:

>> Open one of the affected files.

>> Right-click on a button and choose Assign Macro.

>> Reassign the correct macro manually.

Try Opening Excel in Safe Mode:

>> Hold Ctrl and click the Excel icon.

>> This can help identify if an add-in is causing the issue.

Please let me know if these steps help or if the issue persists. I’ll be happy to assist you further.

Best wishes,

Peter | Microsoft Community Support