I have recently installed Office 365 on a new computer running Windows 8.1 (actually the third one in just over a month, but that’s another story). Office 2013 has several annoying features, but for me the most annoying was that the VBA smart indenter add-in from Office Automation did not work. The web-site only mentions Excel versions up to 2003, but it was working with no problems with Office 365 and Excel 2013 on my last Windows 7 computer, and a search suggests that it should work with Windows 8 and 32 bit versions of Office 2013, but on my machine it doesn’t.
My solution to this problem was to install the alternative smart indenter from Andrew Engwirda. This works on my system with no problems (after reading the installation instructions, you need to enable “Trust access to the VBA project object model” ), and will also work with 64 bit versions of Office.
If anyone else has had a problem with the original code indenter and 32 bit Office, I’d be glad to hear from you, especially if you found a way to make it work, but in the meantime Andrew’s alternative code works just fine.