Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run-time error dialog
Hello!
Is there a way to disable the "Debug" option on the Excel Built in Run-time error Dialog without password-protecting the project? The reason for this is that I have a workbook that sometimes needs to import modules, so I can't have the VB Project password protected. However, the procedures could fail occasionaly, and I want to know about it when it happens, but I don't want the users accidentally hitting the "Debug" button which leads them to the VBE. Any other sugestions to keep users from entering the VBE without having to password protect the workbook? Thanks in advance, Albert C |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
run-time error dialog
Hello
What you could do is place an On Error Goto into the code. -- Roland "Albert" wrote: Hello! Is there a way to disable the "Debug" option on the Excel Built in Run-time error Dialog without password-protecting the project? The reason for this is that I have a workbook that sometimes needs to import modules, so I can't have the VB Project password protected. However, the procedures could fail occasionaly, and I want to know about it when it happens, but I don't want the users accidentally hitting the "Debug" button which leads them to the VBE. Any other sugestions to keep users from entering the VBE without having to password protect the workbook? Thanks in advance, Albert C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run-time error Dialog | Excel Programming | |||
run-time error Dialog | Excel Programming | |||
Error dialog box meaning and how to find error | Excel Worksheet Functions | |||
Error dialog | Excel Programming | |||
Common Dialog Error | Excel Programming |