+ Reply to Thread
Results 1 to 8 of 8

can't debug some subroutines in my project, locked subroutines

  1. #1
    Registered User
    Join Date
    08-03-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    30

    can't debug some subroutines in my project, locked subroutines

    Hi All,

    I've run into a "new-for-me" problem; when I try to debug some of subroutines in my project (say by stepping into with F8) just get a beep and nothing happens.

    I suspect there is a hidden process going on somewhere, which locks them, but I don't know how to find/stop it. I do use the ShellWait sub by Terry Kreft to run some windows batch processes, but as far as I am concerned those run and finish without error.

    Any help will save my sanity, please folks!

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: can't debug some subroutines in my project, locked subroutines

    When exactly do you get the beep?

    Is it when you try to call these sub/functions from other sub/functions?

    Can you post an example of the code?
    If posting code please use code tags, see here.

  3. #3
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: can't debug some subroutines in my project, locked subroutines

    are you trying to step into routines that take arguments?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  4. #4
    Registered User
    Join Date
    08-03-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: can't debug some subroutines in my project, locked subroutines

    Yes, when I'm trying to step into subroutines that take arguments.
    I can't possibly post the code - 5 modules & 5 wks with code

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: can't debug some subroutines in my project, locked subroutines

    I didn't say all the code, an example of the code might do.

  6. #6
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: can't debug some subroutines in my project, locked subroutines

    you can't step straight into routines that take arguments since you can't pass arguments that way

  7. #7
    Registered User
    Join Date
    08-03-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: can't debug some subroutines in my project, locked subroutines

    Thanks JP, I have egg all over my face now.. what a ignoramus


    "There must be a happy medium somewhere between being totally informed and blissfully unaware", Douh Larson

  8. #8
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    I thought you were debugging code that was calling subs.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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