I have locked myself out of my house.
In my workbook, ever gently changing over the last 6 months, I have Application.EnableCancelKey = False set on the Workbook_Open Event (despite the admonition of the help file). The workbook displays a userform requesting a code to proceed further. Application is hidden at this point. Upon entering the correct code, an Automation Error is generated.
30 minutes ago, I added a gif containing the company logo to the startup form (the same form which requests the user code). I believe that something with the gif or the location has caused the Automation Error.
I have tried all possible combinations of Esc, Crtl, Shift, Enter, Break, End, Insert, and Delete in an effort to stop the code at some point so I can get into the VBA project to correct (or at least see) where the problem is.
I have opened the Workbook in question, and then opened another instance of Excel in an effort to see the VBA project of the faulty workbook through the VB editor. Does not work...the project with the automation error is not visible.
Any ideas? Or some other way to break in to my project? <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23> <img src=/S/grovel.gif border=0 alt=grovel width=31 height=23> <img src=/S/bash.gif border=0 alt=bash width=35 height=39>
Any thoughts about writing an add-in to unlock the troubled VBA project? <img src=/S/lightbulb.gif border=0 alt=lightbulb width=15 height=15> <img src=/S/joy.gif border=0 alt=joy width=23 height=23>