Forum Discussion
Macro Issue After Mac Excel 16.85 Update
Hello friends,
The macros that used to work in Mac Excel 16.84 no longer function after the 16.85 Excel update on 05/18/2024. When I click the buttons, the Visual Basic editor opens and gives an "invalid procedure call or argument" error. Even when I right-click the button and select "assign macro," the macro assignment form that opens does not display the macros. The newly created macros do not appear and do not work either.
How can we solve this issue?
Thank you,
- To troubleshoot issues with macros in Excel 16.85 on Mac, follow these steps:
1. Check for updates: Install the latest updates.
2. Check Excel Preferences: Enable all macros in the Security & Privacy section.
3. Recheck Macro Settings: Reassign macros, review code, repair or recreate them.
4. Check for errors: Run each macro from the VBA editor.
5. Check VBA Project References: Check for missing or broken references.
6. Revert to a previous version if possible.
7. Contact Microsoft Support for further assistance.
Try Safe Mode and check Excel Community Forums for similar issues.
