The only thing that I can think of is that the code exits before the
breakpoint, or is bypassed by an IF or a GOTO.
What does the code look like.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"boswald" wrote in
message ...
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