Smart Indenter problem

[LisaGreen]

Hi,

I'm trying to use Smart Indenter. I'm on W8 with Office 2010... In this case Excel and SI V3.5.

Smart Indenter insists on using a tab width of four. My tab setting in the VBE is 2.

1) Anyone else have this problem with this otherwise outstanding software?
2) Anyone know how to fix it please?

TIA
Lisa

[HansV]

As far as I can tell, the Tab Width can't be customized in Smart Indenter.
You could contact Stephen Bullen by sending an e-mail to support@oaltd.co.uk.
(Or go with the flow and set Tab Width to 4 in the Visual Basic Editor options...)

[LisaGreen]

Hey Hans,

Beste Wensen!!!

A bit late but well meant...

For years I thought that was "best events"!

Yeah.... bin there, tried that... and got bounced...

This is an automatically generated Delivery Status Notification.
Delivery to the following recipients failed.
support@oaltd.co.uk

Dunno what's happening with the site... I don't *think* it's been updated in a while now.

Sent the same email to Stephen@oaltd.co.uk... not bounced yet.

Don't want four... sulk sulk... want two. There's a good... I think... reason. I like to keep all of the code visible in the code window and not have to scroll the window right... and anyroad... I think it looks better with two... so there!

Lisa

[HansV]

Gelukkig Nieuwjaar!

Stephen may have retired - perhaps one of our Excel MVPs can comment on that.

(I worked with Tab Width set to 2 for 15 years, for more or less the same reasons as yours, but I switched to 4 a couple of years ago because maintaining/editing code written by others - who usually leave Tab Width set to the default 4 - was more difficult.)

[Jan Karel Pieterse]

I think smart indenter reads the tab width from the wrong registry key. It adheres to tab width in Excel 2003, but it ignores the setting in 2010.
So I think it is read from:
HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common
whereas the settings for the 2010 VBA editor are kept in:
HKEY_CURRENT_USER\Software\Microsoft\VBA\7.0\Common

[Jan Karel Pieterse]

I seem to recall that someone is developing an update to smart indenter that also works on Office 2010 64 bit.

[LisaGreen]

Hey Jan Karel,

... And bete wensen to you too!

You don't by any chance have a link for the smart indenter update please??

Lisa

[LisaGreen]

JKP,

Soooo sorry... I spelt beste wrongly!!

Thank you!

There wasn't a key for 6.0 so I created one and a TabWidth value of 2 and yes!! I have my indentation set to 2 in SI now! Good workaround but if you do remember where the update is I'd still appreciate it.

TIA
Lisa

[Jan Karel Pieterse]

The update is being developed, it is not available yet.

[LisaGreen]

Thanks Jan Karel.

Lisa

[ErikJan]

I'd be interested as well. SI (& MZ-Tools) are my favorite VBA add-ins. I run Excel 2013 (!) but the normal one (so not the 64 bit) and both add-ins had problems and did not load.
I checked the MZ-Tools website and found a newer version which does work so that one is solved.
On SI, I found the discussion in this thread, pity that Stephen doesn't seem to be updating this GREAT tool anymore. I'd be interested to find out when we can expect an alternative or the update as Jan Karel announced was 'in the works'

[ErikJan]

Any news on Smart Indenter yet?

[mirfield]

Just found this thread because I had the same issue.

Thank you for the tip about the key.

If you are comfortable with Regedit then you can fix this manually yourself;

WindowsKey+R (Run)
Enter Regedit
Find key HKEY_CURRENT_USER\Software\Microsoft\VBA\
Right click on the key and add new key "6.0"
Right click on this and add new key "Common"
Right click on this and add new DWORD value "TabWidth"
Double click the value and set it to 2
Exit Rededit

Smart Indent will now use tab size 2.

[Claude]

Herzlich willkommen zur Eileen's Lounge !

Thanks for your Regedit tip, enjoy the lounge.

[goosvanbeek]

Hi all,

I also had an issue installing both MZTools and Smart Indenter om a WIN8-64 Office 2013-32 machine (and read this thread).
After reading this blog
http://www.mztools.com/blog/setup-of-mz ... installed/" onclick="window.open(this.href);return false;
and renaming the mentioned file I was able to install both MZ Tools and Smart Indenter.

I do have the VS2013 Preview installed, but before installing this, I wasn't able to install both add-ins either.
Maybe you can give it a try.

Regards,
Goos van Beek.

[HansV]

Welcome to Eileen's Lounge!

Thanks for your tip - I hope it'll help others with the same problem.

[ErikJan]

I don't have Visual Studio 2013 Preview installed...

[goosvanbeek]

I don't have Visual Studio 2013 Preview installed...

Before installing the VS 2013 preview I also couldn't install MZ Tools and Smart Indenter. Smart Indenter was isntalled, but not visible in the add-in manager. MZ Tools quits the installation with error 0x80073cf9. The error was caused by the Msaddndr.dll, which was not installed by Office 2013, as I found out today.
Yesterday I found the previous mentiond blog entry and renamed the msaddndr.dll. After that I could install MZ Tools (latest version) and and Smart Indenter. Both are available in the add-in manager also.

Today I did the same on another machine with Identical software (Win8-64, Office 2013 (32) and the Visual Studio Preview) installed. After installing both add-ins, they didn't show up in the add-in manager. Weird, I don't know what's causing this issue. As far as I can see, all the necessery register entries are created.

What's your issue with these add-ins?

Edit:
It seemed to be that I installed Office 2013-64 on the second machine.
After installing the 32 version I did the following test:
* Remove C:\Program Files (x86)\Common Files\Designer\MSADDNDR.DLL
* Install Smart Indenter; install succeeded, but not available in the VBE
* Install MZ Tools previous version; install failure with error 0x80073cf9
* Install MZ Tools latest version; install succeded; MSADDNDR.DLL created
* Re-install Smart Indenter; install succeded
* Both add-ins appear in the add-in list and are working fine.

Regards,
Goos.

[ErikJan]

I just re-installed Smart-Indenter (in my Office 2013) and it works... I didn't do anything (but I have the latest MZTools installed...)... probably that fixed it by installing the right DLL. I never tried to install Smart Indenter AFTER I installed MZTools... that must have done it :-)

[Rudi]

Just my 2 cents...
Running Win8 and Office 2013 and did an install of MZ-Tools 3 and then Smart Indenter. Both installed smoothly and both function well in VBA.