I have a routine (CreateTextFile) that accepts a type variable, and
saves the selected cells as a csv or tab file, giving a message box at
the end "file xxx saved".

I have attached it to a toolbar button, with the assigned macro as
'CreateTextFile("tab")".

When I click the button, the macro runs twice - it displays the msgbox
twice.

So it inserted a breakpoint, and the code doesn't stop, it just runs
twice anyway.

I found an entry in this forum - "Breakpoint will not stop Excel
function" posted "03-08-2004, 03:50 PM", but the question of why the
breakpiont gets ignored was not answered.

Does anyone have any ideas why a breakpoint will be ignored?

This routine is definately being run by pressing the button, and if I
call it from another short subroutine and pass it "tab" or "csv" it
runs only once, and breakpoints or single stepping work fine.

Thanks,

boswald


--
boswald
------------------------------------------------------------------------
boswald's Profile: http://www.excelforum.com/member.php...o&userid=26566
View this thread: http://www.excelforum.com/showthread...hreadid=398407