break mode

  1. J

    Run-Time Error 1004 when Stopping Application.OnTime Procedure

    I wrote a macro that allows a user to time the duration of their call through a UserForm, while they continue to enter data about their call on an excel sheet. Most of the time the macro works perfectly but occasionally (randomly it seems) I get an error when attempting to pause/stop the OnTime...
  2. E

    Code runs in break mode, but not otherwise!

    Hi all, I have a code that is replacing hyperlinks to open word documents on a networked document as everyone has a unique identifier for the initial drive on the network. For example, I am on the H drive, but the same document for a colleague is on the N drive. I've created a range in excel...
  3. O

    Get to know if in Break-Mode and/or on what line?

    Is there a way to know programmatically that we are in BreakMode and maybe even know on what line? I found out that using apostrophes one can start OnTime with parameters and not having the error "Can't execute code in break mode". Application.OnTime now, "'MySub " & now & "'" This will...
  4. H

    Pivot Table refresh only works in debug mode..!?

    Hi all, I have a workbook which contains a link to an external SQL procedure to bring in data. The user will select parameters in the spreadsheet and run the macro to retrieve the data and then will be shown a pivot table of the results. The data actually goes initially into a normal table...
  5. P

    Break Mode message

    I'm currently working on some VBA code and I'm getting a strange "can't execute code in break mode" error. The macro runs fine in excel, but the problem arises when I try debugging it with VBA. Any time I step past a line selecting a different sheet or adding a new one this message box appears...
  6. E

    Delete OLEObjects in Break Mode

    Hi, I am writing some code that will create random data which will be used in a specific sheet to calculate certain values using the cell formulas. This sheet will be copied as many times as necessary to input the numbers generated (The code will generate a different set of numbers for a...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top