| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
code execution has been interrupted
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 |
|
#2
|
|||
|
|||
|
Take a look at:
application.EnableCancelKey in VBA's help. Read the warning in there about a "runaway" loop. François wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i create an access code sheet to number my office files an. | New Users to Excel | |||
| Help with Amending this Code Please | Excel Worksheet Functions | |||
| Command Button VBA code | Excel Discussion (Misc queries) | |||
| Often-Used Code not working in a new Workbook | Excel Discussion (Misc queries) | |||
| Zip Code Macro | Excel Worksheet Functions | |||
Linear Mode
