Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Breakpoint will not stop Excel subroutine
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To stop Excel from opening many workbooks at startup | Excel Discussion (Misc queries) | |||
How can I stop Excel from displaying rounded numbers? Credit car. | Excel Discussion (Misc queries) | |||
stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions | |||
How do I stop the autopaste function in Excel? | Excel Worksheet Functions | |||
How do I stop automatic page breaks in excel | Excel Worksheet Functions |