Can't enter break mode at this time message - microsoft.public.mac.office.excel

Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I'm trying to step through some simple code in a macro using the VB Editor step into command. I have a statement in the macro: Sheets("DATA").Move _ Before:=Workbooks("Test.xls").Sheets(1) For some reason, this causes the Can't enter break mode message to pop up. I can Continue, End or Help in the Popup. Continue finishes the macro, but doesn't let me step through the remaining statements. All the stuff I've found at google talks about ActiveX controls and extensibility add-in object model. I'm not using any forms or controls in the workbook, so I can't imaging why this is happening. If I step through the same code on Excel 2007 it works just fine--no can't enter break mode message. Any suggestions?

> This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3343052257_1929720 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit On 12/7/09 3:11 PM, in article 59bae610.-1@webcrossing.JaKIaxP2ac0, "Theodore_MH@officeformac.com" <Theodore_MH@officeformac.com> wrote: > Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I'm > trying to step through some simple code in a macro using the VB Editor step > into command. I have a statement in the macro: > > Sheets("DATA").Move _ > Before:=Workbooks("Test.xls").Sheets(1) > > For some reason, this causes the Can't enter break mode message to pop up. I > can Continue, End or Help in the Popup. Continue finishes the macro, but > doesn't let me step through the remaining statements. All the stuff I've > found at google talks about ActiveX controls and extensibility add-in object > model. I'm not using any forms or controls in the workbook, so I can't > imaging why this is happening. If I step through the same code on Excel 2007 > it works just fine--no can't enter break mode message. > Any suggestions? What happens if the statement is on a single line? -- Bob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom --B_3343052257_1929720 Content-type: text/html; charset="US-ASCII" Content-transfer-encoding: quoted-printable <HTML> <HEAD> <TITLE>Re: Can't enter break mode at this time message</TITLE> </HEAD> <BODY> On 12/7/09 3:11 PM,= in article <a href=3D"59bae610.-1@webcrossing.JaKIaxP2ac0">59bae610.-1@webcro= ssing.JaKIaxP2ac0</a>, "<a href=3D"Theodore_MH@officeformac.com">Theodore= _MH@officeformac.com</a>" <<a href=3D"Theodore_MH@officeformac.com">Th= eodore_MH@officeformac.com</a>> wrote: <BLOCKQUOTE>Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: In= tel I'm trying to step through some simple code in a macro using the VB Edit= or step into command. I have a statement in the macro: Sheets("DATA").Move _ Before:=3DWorkbooks("Test.xls").Sheets(1) For some reason, this causes the Can't enter break mode message to pop up. =  I can Continue, End or Help in the Popup.  Continue finishes the = macro, but doesn't let me step through the remaining statements.  All t= he stuff I've found at google talks about ActiveX controls and extensibility= add-in object model.  I'm not using any forms or controls in the workb= ook, so I can't imaging why this is happening.  If I step through the s= ame code on Excel 2007 it works just fine--no can't enter break mode message= ..   Any suggestions? </BLOCKQUOTE>What happens if the statement is on a single line? -- Bob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom<SP= AN STYLE=3D'font-size:10pt'> </BODY> </HTML> --B_3343052257_1929720--

Hi Bob, Actually, the statement is on just one line. I broke it in the post so it fit in the text box. Curiously, I found a sort-of workaround for the problem. If I do not require declared variables in the Visual Basic editor preferences, the problem does not occur. I can't figure how that has anything to do with the problem, but I tested a bunch and when that preference checkbox is checked I get the problem. Checkbox cleared, no problem. Now I just have to turn off required variables before I step through a program, then turn them back on when I'm doing other stuff. Thanks for your reply. > On 12/7/09 3:11 PM, in article 59bae610.-1@webcrossing.JaKIaxP2ac0, "Theodore_MH@officeformac.com" <Theodore_MH@officeformac.com> wrote: > > Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I'm trying to step through some simple code in a macro using the VB Editor step into command. I have a statement in the macro: > > Sheets("DATA").Move _ > Before:=Workbooks("Test.xls").Sheets(1) > > For some reason, this causes the Can't enter break mode message to pop up. �I can Continue, End or Help in the Popup. �Continue finishes the macro, but doesn't let me step through the remaining statements. �All the stuff I've found at google talks about ActiveX controls and extensibility add-in object model. �I'm not using any forms or controls in the workbook, so I can't imaging why this is happening. �If I step through the same code on Excel 2007 it works just fine--no can't enter break mode message. � > Any suggestions? > What happens if the statement is on a single line? > > -- > Bob Greenblatt [MVP], Macintosh > bobgreenblattATmsnDOTcom > >

That usually means you have a spelling mistake somewhere (else!) in the code module :-) Cheers On 8/12/09 10:06 AM, in article 59bae610.1@webcrossing.JaKIaxP2ac0, "Theodore_MH@officeformac.com" <Theodore_MH@officeformac.com> wrote: > Hi Bob, > > Actually, the statement is on just one line. I broke it in the post so it fit > in the text box. > > Curiously, I found a sort-of workaround for the problem. If I do not require > declared variables in the Visual Basic editor preferences, the problem does > not occur. I can't figure how that has anything to do with the problem, but I > tested a bunch and when that preference checkbox is checked I get the problem. > Checkbox cleared, no problem. > > Now I just have to turn off required variables before I step through a > program, then turn them back on when I'm doing other stuff. > > Thanks for your reply. > >> On 12/7/09 3:11 PM, in article 59bae610.-1@webcrossing.JaKIaxP2ac0, >> "Theodore_MH@officeformac.com" wrote: >> >> Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I'm >> trying to step through some simple code in a macro using the VB Editor step >> into command. I have a statement in the macro: >> >> Sheets("DATA").Move _ >> Before:=Workbooks("Test.xls").Sheets(1) >> >> For some reason, this causes the Can't enter break mode message to pop up. �I >> can Continue, End or Help in the Popup. �Continue finishes the macro, but >> doesn't let me step through the remaining statements. �All the stuff I've >> found at google talks about ActiveX controls and extensibility add-in object >> model. �I'm not using any forms or controls in the workbook, so I can't >> imaging why this is happening. �If I step through the same code on Excel 2007 >> it works just fine--no can't enter break mode message. � >> Any suggestions? >> What happens if the statement is on a single line? >> >> -- >> Bob Greenblatt [MVP], Macintosh >> bobgreenblattATmsnDOTcom >> >> -- The email below is my business email -- Please do not email me about forum matters unless I ask you to; or unless you intend to pay! John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer, McGhie Information Engineering Pty Ltd Sydney, Australia. | Ph: +61 (0)4 1209 1410 +61 4 1209 1410, mailto:john@mcghie.name

Similiar Articles:

Can't enter break mode at this time message - microsoft.public ...
Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I'm trying to step through some simple code in a macro using the VB Edit...

2007 Shared vs Split Database - microsoft.public.access ...
... the Microsoft "Send" Don't Send" message ... means that only one user can open the database for RW at a time. ... of Access installed, you can click on Start > Run, and enter ...

Expand Abbreviations For State Names - microsoft.public.excel.misc ...
... code module, open the workbook, press [Alt]+[F11] to enter ... when I run it I get the following error message: > > Can't execute the code in break mode > > I'm new ...

Not saving the record to my table. Any ideas why? - microsoft ...
The idea is that people can enter data directly ... discussions.microsoft.com> wrote in message ... You can't save this record at this time - microsoft.public ...

clearing the immediate window - microsoft.public.access ...
Every time I rerun the code I want to clear the ... "Keith G Hicks" <krh@comcast.net> wrote in message ... It’s probably not a good idea to enter break mode while this ...

Toolbar icon - page break? - microsoft.public.mac.office.word ...
... Section Break and Insert-Column Break, I can't find ... I avoid about a 20% time impediment b= y ... > Using Shift-Enter (the regular return key) doesn't accomplish anything.

Can't Enter New Record in Subform - microsoft.public.access ...
I used a union query to break it out and added an index. ... since he tried to talk me out of all this some time ... Can't Enter New Record in Subform - microsoft.public.access ...

Option Group, Unbound Form: 2467 Object closed or doesn't ...
... y.Invalid> wrote in message news ... optWhichSheets.Name You *can* use Me if you're in break mode. ... 2467 Object closed or doesn't ... I'm getting a run-time ...

Wordwrapping a long sentence using F2, how to end the process ...
> > > > Can you tell me how to use the F2 mode correctly? ... does the job all by itself, but I can't ... > > > > And I think that each time I've used alt-enter, excel has ...

How to code macro to disconnect internet connection? - microsoft ...
... close connections all the time ... formum that gets the same messages ... You can't break the links. Either you have to turn the Recalculation mode off, or repalce the ...

Can't enter break mode at this time - MrExcel Message Board
Question Forums > Excel Questions ... Hi All I am trying to step into some code to find out what is happening at a cretain point but everytime I get to this part ...

Can't Enter Break Mode at this Time - MrExcel Message Board
Question Forums > Excel Questions ... Can anybody tell me exactly what it is that causes this message when trying to step ... http://support.microsoft.com/default ...

Can't enter break mode at this time - Microsoft Corporation ...
Error Messages ... Enum types defined in standard modules or ... Can't enter break mode at this time

Excel/VBA Message - "Can't enter break mode at this time": break ...
I have a workbook with (among others) worksheets named 'Week 1' to 'Week 13' There is a menu from which a user can select to 'Move on a week' In this ...

7/23/2012 3:25:42 AM