none
Visual Basic debug mode start button stays grey RRS feed

  • Question

  • I am working in the Excel Visual Basic Editor and when debugging the stop button stays grey.

    I can't stop the debugging?

    How can I activate the stop button in the debug mode?

    Thanks for any support,

    Marcel


    Saturday, December 10, 2016 2:16 PM

Answers

All replies

  • Hi Marcel,

    If your debug button is grey that mean that there's a error when you debug your code. check correctly the Macro execution.

    http://blog.contextures.com/archives/2014/09/04/excel-vba-problem-with-step-into-f8/

    NOTE :Please remember to click Mark as Answer the responses that resolved your issue, and to click Unmark as Answer if not.

    Kind Regard.


    The formal education will help you make a life. The self-education will help you make a fortune.Please remember to click Mark as Answer the responses that resolved your issue, and to click Unmark as Answer if not.


    • Edited by Eddysha Jabulani Saturday, December 10, 2016 2:44 PM
    • Proposed as answer by James Cone Sunday, December 11, 2016 1:38 PM
    Saturday, December 10, 2016 2:40 PM
  • Thank you for your quick reply.

    So far as I know there is no error.

    See code

    ---

    Sub StopTest()

        Dim Stopper As Integer
        
        Stopper = 10
        
    End Sub

    ----

    When I stand in the subroutine and press F8, than the button stays grey.

    Each F8 makes VB go one line further so that is fine.

    This is a very short Subroutine, but with longer sub routine or multiple subs I wan to be able to stop the code.

    Kind regard

    Saturday, December 10, 2016 2:52 PM
  • Hi MarcelStartVB,

    are you trying to run the code from Password protected workbook or worksheet?

    in this situation debug button turns to gray (disable).

    if yes, then  open up the VB Editor (Alt-F11), navigate to the project in question, expand it, provide the password and then re-run the code.

    if that not work for you then try to create a new workbook and try to add some code and debug. check that it happens with every workbook or the issue is only related with particular workbook.

    if that happens with every workbook then try to repair the MS Office and again try to debug the code.

    let us know about your testing results so that we can try to give you further suggestions.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Monday, December 12, 2016 2:56 AM
    Moderator
  • Dear Deepak,

    Thank you for your suggestions.

    I have checked that it is an unprotected workbook.

    I have started a new workbook and made a simple subroutine.

    I have updated Excel (I have Office 365) to the latest version.

    Still the stop button stays gray (disable).

    Regards, Marcel


    Monday, December 12, 2016 11:01 AM
  • Hi MarcelStartVB,

    please try to Repair or Reinstall the MS Office.

    it is possible that There is something get corrupted in VBE but latest update didn't update anything in VBE.

    so updating to the latest version did not solve the issue.

    so we have only this way available to correct it.

    by Repairing or Reinstalling the MS Office it can solve the issue.

    please let me know about the results after implementing the above mentioned suggestion.

    I think that you can also reproduce the same issue for other MS Office Applications too.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, December 13, 2016 3:05 AM
    Moderator
  • Thank you, I will look how to repair MS Office.

    Regards, Marcel

    Wednesday, December 14, 2016 12:10 PM
  • Hi MarcelStartVB,

    let us knw about the results after repairing the MS Office.

    so that if the problem not solved with that then we can try to suggest you further to solve the issue.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, December 15, 2016 5:08 AM
    Moderator
  • Dear Deepak,

    I have fully reinstalled Office 365.

    The problem stil insists.

    Opened a blank spreadsheet and added the following code:

    Sub sound()
          Beep
    End Sub

    Started the sub with F8, but couldn't stop, the stop button was still gray.

    The same problem also in Word.

    Regards,

    Marcel


    Thursday, December 15, 2016 8:11 PM
  • Dear Deepak,

    I solved the problem.

    I added the button once more in the tool bar and than the stop button turned on.

    The older stop button stayed gray, but I have throwed it away.

    Solved, but I don't get it ;-)

    Cheers, Marcel


    Thursday, December 15, 2016 9:29 PM
  • Hi MarcelStartVB,

    From your last replay it looks like your issue is solved now.

    so I suggest you to mark your last reply as an answer.

    it will help us to close this thread.

    if you don't mark the answer then this thread will open forever.

    so please take the mark action.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, December 16, 2016 5:47 AM
    Moderator