Password protected VBA module problem

[AmericanSeiko]

Password protected VBA module causes Excel to crash on debugs. Macros work fine if I open VBE and enter my password.

I'm using Range.("This range does not exist").Select to force a debug.

If I run my macro without entering my module password, the debug window appears and Excel crashes.

If I run my macro after entering my module password, the VBE window opens and it debugs normally.

I'm 90% sure the password protection is the problem. I want to keep my code password protected, but I don't want my project to crash on an error. Any ideas on how to fix/workaround this?

Thanks everyone!

 

[mikerickson]

Your code is password protected, so the Debug window will work only if you enter the password.

The only solution is to gorilla proof your code, writing your own error handling to handle the errors that come up. Something like this perhaps.

Sub MySub()
    On Error Goto MyHandler
    ' some code
    Range.("This range does not exist").Select
    ' more code
    On Error Goto 0
    Exit Sub
MyHandler:
    MsgBox "Error: " & Err & vbcr & Error
End Sub

 

[AmericanSeiko]

MyHandler:
MsgBox "Error: " & Err & vbcr & Error

Thank you! That completely solved my problem. I've worked with custom error handlers before, but I don't know what " & Err & vbcr & Error" do. Would you care to enlighten me?

Thanks again for answering my question!

 

[mikerickson]

Err and Error are system messages giving the number and text description of a VB error that occurs.

In the example given Err was 1004 and Error was "Method 'Range' of Object' _Global failed"