code execution has been interrupted

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

Guest

Hello,

Is there a way to avoid the user to stop the process of a macro.
The reason for this is very simple : in the macro the sheet is deprotected
at the beginning and reprotect at the end. Therefore to avoid the user to
find a unprotected sheet whenever he stops the macros, I would like to set
the unbreakable switch to on.

Many thanks for your valuable help.

François
 
Take a look at:

application.EnableCancelKey

in VBA's help.

Read the warning in there about a "runaway" loop.
 
You must log in or register to reply here.

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

Similar Threads

Macro to allow auto filter after running password protect 1
Spell Check Protect Reprotect with same settings 1
Macro with protect sheet 1
CODE EXECUTION INTERRUPTED 2
Stop window saying code execution interrupted at startup? 1
"Code execution has been interrupted" message 5
possible to record vba editing as a macro 5
Code Execution Interrupted 1

Back
Top