Made the mistake to run the freeware program Smart Indenter before checking
all the code is fine with a compile.
Result is the Smart indenter progress bar is stuck and
the VBE is frozen. Unless I can get this unstuck without
closing the VBE I will lose about an hour of work.

Any suggestions?

Any help greatly appreciated here!

RBS

Hi RBS,

I have no answer, merely a comment.

If you refer to Stephen Bullen's Smart Indenter, I use it continually and I
have never felt (or had) the need to pre-compile code. Indeed, it is
frequently a most useful aid on uncompiled development code.

Furthermore, I have never experienced any problem with the indenter no
matter how complex the code, no matter how 'unreasonable' the code and no
matter how intrinsically uncompilable the code.


---
Regards,
Norman



"RB Smissaert" wrote in message
...
Made the mistake to run the freeware program Smart Indenter before
checking all the code is fine with a compile.
Result is the Smart indenter progress bar is stuck and
the VBE is frozen. Unless I can get this unstuck without
closing the VBE I will lose about an hour of work.

Any suggestions?

Any help greatly appreciated here!

RBS

Hi Norman,

Yes it is Stephen Bullen's Smart Indenter.
Well, tried all kind of complex things (including messing with a C++
debugger) to get out without
losing the work, but in the end I just gave up and killed Excel.
I have seen this many times, that is freezing up the indenter, but I did a
search for it and never seen anybody
else mentioning it. Maybe it is because I am dealing with a really big .xla
add-in, over 4 Mb.
I was only indenting one Sub though.
I have now updated to the latest version, but even my previous version was
quite recent.
Will see if I can reproduce and if anybody is interested in it I can post
the workbook.
Maybe it is relevant that there are other COM add-ins installed such as MZ
Tools.

RBS


"Norman Jones" wrote in message
...
Hi RBS,

I have no answer, merely a comment.

If you refer to Stephen Bullen's Smart Indenter, I use it continually and
I have never felt (or had) the need to pre-compile code. Indeed, it is
frequently a most useful aid on uncompiled development code.

Furthermore, I have never experienced any problem with the indenter no
matter how complex the code, no matter how 'unreasonable' the code and no
matter how intrinsically uncompilable the code.


---
Regards,
Norman



"RB Smissaert" wrote in message
...
Made the mistake to run the freeware program Smart Indenter before
checking all the code is fine with a compile.
Result is the Smart indenter progress bar is stuck and
the VBE is frozen. Unless I can get this unstuck without
closing the VBE I will lose about an hour of work.

Any suggestions?

Any help greatly appreciated here!

RBS

Hi RB,

Well, tried all kind of complex things (including messing with a C++
debugger) to get out without
losing the work, but in the end I just gave up and killed Excel.
I have seen this many times, that is freezing up the indenter, but I did a
search for it and never seen anybody
else mentioning it. Maybe it is because I am dealing with a really big .xla
add-in, over 4 Mb.
I was only indenting one Sub though.
I have now updated to the latest version, but even my previous version was
quite recent.
Will see if I can reproduce and if anybody is interested in it I can post
the workbook.
Maybe it is relevant that there are other COM add-ins installed such as MZ
Tools.

While pretty robust, there are, I'm sure, bugs in the code - something that it
simply doesn't handle (probably to do with line continuations!). I'm always
willing to take a look at code that makes the indenter freeze and fix it.

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev

Stephen,

Thanks; I will see if I can put together a small workbook that demonstrates
it and mail it to you. I think the problem only arises when the code is
un-compilable.

RBS


"Stephen Bullen" wrote in message
...
Hi RB,

Well, tried all kind of complex things (including messing with a C++
debugger) to get out without
losing the work, but in the end I just gave up and killed Excel.
I have seen this many times, that is freezing up the indenter, but I did
a
search for it and never seen anybody
else mentioning it. Maybe it is because I am dealing with a really big
.xla
add-in, over 4 Mb.
I was only indenting one Sub though.
I have now updated to the latest version, but even my previous version
was
quite recent.
Will see if I can reproduce and if anybody is interested in it I can post
the workbook.
Maybe it is relevant that there are other COM add-ins installed such as
MZ
Tools.

While pretty robust, there are, I'm sure, bugs in the code - something
that it
simply doesn't handle (probably to do with line continuations!). I'm
always
willing to take a look at code that makes the indenter freeze and fix it.

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev

Stephen,

Would it not be possible to add an error handler that at least won't let you
lose the changes?

RBS


"Stephen Bullen" wrote in message
...
Hi RB,

Well, tried all kind of complex things (including messing with a C++
debugger) to get out without
losing the work, but in the end I just gave up and killed Excel.
I have seen this many times, that is freezing up the indenter, but I did
a
search for it and never seen anybody
else mentioning it. Maybe it is because I am dealing with a really big
.xla
add-in, over 4 Mb.
I was only indenting one Sub though.
I have now updated to the latest version, but even my previous version
was
quite recent.
Will see if I can reproduce and if anybody is interested in it I can post
the workbook.
Maybe it is relevant that there are other COM add-ins installed such as
MZ
Tools.

While pretty robust, there are, I'm sure, bugs in the code - something
that it
simply doesn't handle (probably to do with line continuations!). I'm
always
willing to take a look at code that makes the indenter freeze and fix it.

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev

Stephen,

Will see if I can send you a WB today.

RBS

"Stephen Bullen" wrote in message
...
Hi RB,

Would it not be possible to add an error handler that at least won't let
you
lose the changes?

I'm guessing that there's an infinite loop somewhere - probably in the
routine
that handles the line continuations. It'll be easiest for me to identify
where
with some sample repro code.

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev

Hi RB,

Would it not be possible to add an error handler that at least won't let you
lose the changes?

I'm guessing that there's an infinite loop somewhere - probably in the routine
that handles the line continuations. It'll be easiest for me to identify where
with some sample repro code.

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev

Stephen,

This is not easy to reproduce.
I am not sure if this is because I have installed a newer version or because
the indenter only freezes after you have
made a lot of changes.
The trouble is even if I can reproduce it I can't show you the code as the
changes are lost with the frozen indenter.
Will let you know if I can show it.

RBS


"Stephen Bullen" wrote in message
...
Hi RB,

Would it not be possible to add an error handler that at least won't let
you
lose the changes?

I'm guessing that there's an infinite loop somewhere - probably in the
routine
that handles the line continuations. It'll be easiest for me to identify
where
with some sample repro code.

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev

Hi RB,

This is not easy to reproduce.
I am not sure if this is because I have installed a newer version or because
the indenter only freezes after you have
made a lot of changes.
The trouble is even if I can reproduce it I can't show you the code as the
changes are lost with the frozen indenter.
Will let you know if I can show it.

Thanks!

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev