| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect macro from stopping
How can I prevent users to stop the macro from running. If macro is doing its
thing and you press ESC button it will stop and I don't want that to happen. Is there any way? thx. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200708/1 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect macro from stopping
Look at the EnableCancelKey property in VBA Help.
Make sure you provide an error handler - clients/users tend to get perturbed if you leave them in an endless loop. They also tend to abort applications that *appear* to be hung, so you might instead consider a custom error handler that handles the ESC key rather than just disabling it. In article <76cb3d4443159@uwe, "saman110 via OfficeKB.com" <u35670@uwe wrote: How can I prevent users to stop the macro from running. If macro is doing its thing and you press ESC button it will stop and I don't want that to happen. Is there any way? thx. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect macro for unauthorised use | Excel Discussion (Misc queries) | |||
| Protect sheet in macro | Excel Worksheet Functions | |||
| Protect macro | Excel Discussion (Misc queries) | |||
| Stopping Excel macro pattern recgonition | New Users to Excel | |||
| How to protect my macro | Excel Discussion (Misc queries) | |||
Linear Mode
