View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Albert Albert is offline
external usenet poster
 
Posts: 203
Default 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