Check out help on: Application.InterActive = False

This command effectively locks the keyboard and mouse. Use it with caution,
read help first.

"Rajeev" wrote:

Hi:

I have a VBA code that is triggered when workbook is opened. If a user
interrupts the execution (say, by pressing ESC key) as the code is being
executed (code has multiple user authentication checks and reformmating and
hiding of sheets per user's access level), the user gets this "Code
Interruption Dialog" where they can click on End execution button. By
pressing End button, the user can get access to undesired sheets/cells. My
question is if I can stop this code interruption in Excel so that I can
prevent access to undesired sheets/cells. Any ideas?

Thanks
Rajeev