run-time error Dialog

A

Albert

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top