Forum Discussion
Macros crashed Word, then disappeared, now back again but not working
My problem started with a few macros in Word (Office 365) crashing Word, then the list macros, while still showing up with Alt+F8, disappeared from VBA. I played around with templates and such, and now have the VBA showing the whole list of macro scripts. However, there is a red scroll icon on my macros list and I have had the message "Your organizations administrator turned off the service required to use this feature", which is odd because I am the administrator (this is a home Office 365 subscription). So I can see the macros in VBA but I can't run any of them, nor can I create any new macros. How do I get my macros up and running again? (I tried to 'repair' Office, and after the full repair ended up with a version of Word that isn't as customised as it used to be.) And what might be the cause of this problem?
1 Reply
Try this:
- Enable Macros in Trust Center
Go to:
- File → Options → Trust Center → Trust Center Settings
- Click Macro Settings
- Choose:
Trust access to the VBA project object model
- Add Your Templates to Trusted Locations
- Go to Trusted Locations
- Add the folder(s) where your macros or templates live (e.g., Normal.dotm, custom templates, etc.)
- Check File Format
Make sure your macro-enabled documents are saved as:
- .docm (not .docx, which doesn’t support macros)
- Repair Didn’t Fully Restore Settings
Since you mentioned doing a repair:
- It may have reset your customizations and macro settings.
- Reapply your Trust Center settings and recheck your macro locations.