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 "in...
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.
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.