SmartIndent in Excel2007

[ErikJan]

I'm old and years behind, hope you can forgive some obvious questions in the next couple of posts about Excel 2007 (which, I know, is already almost outdated itself, I might just upgrade to 2010 soon... here @ home but @ work I'm stuck to 2003 and by year end for four years probably to 2007)...

I always use(d) Stephen Bullen's SmartIndent to tidy up my VB(A) code. Now, in my Excel 2007 / Win7(64) I wanted to re-install but Stephen's website mentions Excel 2003 and nothing beyond that... am I out of luck?

[mbarron]

You can install it if you are using 2007. It works on my machine at least. I'm using SmartIndenter v3.5 currently.

[HansV]

In addition to mbarron's reply: the Visual Basic Editor in Office 2007 is still the same as in previous versions (except that the VBA help has become even worse than it was in Office 2003; it's virtually useless now), so add-ins for the VBE that worked in previous versions should still work in Office 2007.

[ErikJan]

That works... thanks!

[rory]

(except that the VBA help has become even worse than it was in Office 2003; it's virtually useless now)

The Offline Help is a lot better than the Online one. Not saying a lot though...

[HansV]

I agree that the offline help is better than the laughably inadequate online help. But since the excellent help files for the Excel macro language, quality has gone downhill with each new version. Same for Word and Access...