Tuesday, 31 May 2016

VBA Code Indenter v1.5

I've made some changes to my VBA Code Indenter.

For a start, it's now a xlam file. (Sorry, Excel 2007 or higher from now on). I also changed the code to automatically open the Trust Center so you can tick "Trust access to the VBA project object model", if it's not ticked already.




Finally, I changed the code to refer to the Code Window command bar. Some people who downloaded the tool said it was not appearing in the Visual Basic Editor as expected. To this end, I made an alternative tool that shows in the Excel ribbon instead. Anyway, I think the new version should have that problem beat - send an email to the address on the left of this blog if you have issues.

Here's the download link. Happy Indenting!