There is one more, much more serious problem.
If you run the indenter and there is a syntax error in your
code then the indenter code can go in an endless loop, freezing it up.
There is no other way out of this then to kill Excel with Ctrl + Alt + Del.
This means losing all your work if you are working on an .xla project
and possibly also if you were working on an .xls file.
So, best always to run Debug, Compile before running the indenter.
Not sure if this serious bug has been fixed in the latest version, but I
sure
have wasted several hours work due to this.
RBS
"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
installed this and found a problem. it seems to delete shortcut keys
assigned to a macro. i have control-shift-r assigned to a code module that
print previews a report.
after running indent project, or opening the module and running indent
procedure, the shortcut is deleted. go to the options for the macro and
it's blank.
just thought i'd pass it on. sent the author an email, too.
it does do a good job, though.
--
Gary
"RB Smissaert" wrote in message
...
http://www.oaltd.co.uk/Indenter/Default.htm
RBS
"Edward" wrote in message
ps.com...
Is there a way to auto-indent code in the VB editor for macros in
Excel? That is, if my code looks like:
if a = 7 then
call b
end if
change it to:
if a = 7 then
call b
end if
Thanks.
Edward