Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Disable the Debug button? (Excel 2000 >)

    Hi all,

    Is there a way to disable the debug button using VBA code? I sometimes see the dialog appear with the button disabled. If this is possible I can take advantage of it??!
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Disable the Debug button? (Excel 2000 >)

    You should include error handling in all code meant for end users, so that this dialog will never appear.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Disable the Debug button? (Excel 2000 >)

    <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15> Yes I believe that is the idea! Are you going witty on me know??? (I'll tell Geoff what you are doing!! <img src=/S/cop.gif border=0 alt=cop width=15 height=24>)

    OK...so I gather by your answer that its not possible?
    Regards,
    Rudi

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Disable the Debug button? (Excel 2000 >)

    I don't understand. During development, you want to be able to use the Debug button, you wouldn't want it to be disabled. When you turn over a workbook to end users, you should have error handling in your code, so that they never see the Continue / End/ Debug / Help dialog, with Debug enabled or disabled.

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Disable the Debug button? (Excel 2000 >)

    Hans...you don't need to understand. I think I am going a bit DAFT!! You are absolutely correct! I don't think I brainstormed enough over the answer. I recall a friend asking me the question and when this popped up as a query from a client I just posted the Q to get some response.

    Thanx for bringing me back to earth on this one! (Shuttle and all!!) <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Regards,
    Rudi

Posting Permissions

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