+ Reply to Thread
Results 1 to 2 of 2

Can't enter break mode at this time

  1. #1
    Registered User
    Join Date
    10-13-2019
    Location
    Windsor, Canada
    MS-Off Ver
    Excel 2007
    Posts
    24

    Can't enter break mode at this time

    Hi.
    I'm having issues with deleting a line of code in my ThisWorkbook Workbook open event. it worked at one time then suddenly it stopped working. It doesn't give me an error when I run the program, but it just doesn't delete the line of code. When I open the sub and step through it I get the error code "Can't enter break mode at this time." I've checked to make sure the line number was 42 & I want to delete only that line. Here is the code:
    Help will be appreciated

    Edited: If I step through the file and get the error then hit continue or end it deletes the code like it should... but does not go to "End With"
    I tried to input the line "On Error Resume Nest to try to override the error...well that line of code doesn't work on anything that I've tried

    Going to bed...will check back tomorrow if anyone can help

    Thanks
    Please Login or Register  to view this content.
    Last edited by Effexus3; 12-17-2019 at 02:27 AM.
    SomePlansFailOnExecution

    AllPlansFailWithout

  2. #2
    Registered User
    Join Date
    10-13-2019
    Location
    Windsor, Canada
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Can't enter break mode at this time

    I've cross posted this on 2 other forums
    https://www.excelguru.ca/forums/show...2746#post42746

    https://www.ozgrid.com/forum/index.p...-at-this-time/
    Thanks Jim
    Last edited by Effexus3; 12-22-2019 at 11:51 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Error: Cant enter break mode at this time..
    By Vivek2705 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2019, 09:07 AM
  2. [SOLVED] Can't enter break mode only sometimes
    By carsto in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-09-2017, 04:46 PM
  3. [SOLVED] "Can't enter break mode at this time" (Issues with adding controls at runtime)
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 12-16-2013, 07:10 PM
  4. "Can't enter break mode at this time" error
    By jp001 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-11-2009, 09:19 AM
  5. "Can't enter break mode at this time"
    By Paul T. in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2006, 07:00 PM
  6. Can't enter break mode at this time
    By CWillis in forum Excel General
    Replies: 2
    Last Post: 06-01-2006, 02:45 PM
  7. received message: Can't enter break mode at this time
    By William Weder in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2006, 10:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1