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

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