Error when Writing code by macro

**bagullo** · 04-10-2012, 10:11 AM

Hi,

this might be a bit over-the-edge, but it's driving me crazy.
I have a macro that creates a file with a toolbar, and thus it adds the code for the bar to appear and disappear when de workbook is activated/deactivated etc.

this macro works beautifully, but I in some instances it does produce an error which makes excel to crash entirely.

Has anyone experience in writing code in "thisworkbook" by ".insertlines"

any way to prevent the error or at least see what is causing it to crash?

thank you very much indeed

should I change then default vbproject name to avoid conflicts??

With the debugger I see that the macro does copy standard modules and even userforms, it crashes at the point in which it writes the first process in "Thisworkbook"

any help will be welcome

**rvasquez** · 04-10-2012, 10:17 AM

Hello Bagullo,

Have you tried putting on error resume next or an errorhandler within your code?

**Leith Ross** · 04-10-2012, 10:51 AM

Hello bagullo,

I have done this many times without crashing Excel. It would help if you post the post that is causing the problem.

**bagullo** · 04-11-2012, 08:03 AM

Hi,

I have tried putting an error handler, but the problem persists -- as mentioned, when the error happens the whole excel crashes, not just showing the debugger

and here is the code where the error happens

the thing is that the code DOES work perfectly in all other 99% of times -- just checking what can be causing such an error

Please Login or Register  to view this content.

Any clues on what can I try ?

sometimes it works fine the first time and then does not work again for a while... but today didn't work even on a fresh attempt first thing in the morning :S

this is confusing!