Prevent Excel VBA Code from being Interrupted

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Found my answer through another Post
Application.EnableCancelKey = xlDisabled
in the the beginning of code to prevent it from being interrupted

Thanks anyway
 
To prevent Cancellation, as first row of the _Open, use:
application.EnableCancelKey=False
then later reset it :
application.EnableCancelKey=True

Be aware that setting it to False can be a major problem if the code enters
an infinite loop, you have no way to stop it and get back to design mode.

For the "per user's access level", to prevent any problem of data
visibility, hide all data sheets as xlSheetVeryHidden before saving the book
so when it opens, nothing is visible, then after authentification, unhide the
right sheets.

Regards,
Sebastien
 
Check out help on: Application.InterActive = False

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