Lock Keyboard input

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

Guest

How do I Lock Keyboard input while running Macro? User can press Esc Key to
stop a Macro from running, how do I prevent this?
 
In my procedure i use this code ....
Sub DisableCancel()
Application.EnableCancelKey = xlDisabled
For i = 1 To 60000
Cells(i, 1) = i
Next
Application.EnableCancelKey = False
End Sub


just replace
For i = 1 To 60000
Cells(i, 1) = i
Next

by your code
 

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

keyboard press indication 1
How to get Last Key or Key-Combo Pressed (Not Event)? 0
Please help: Interrupt routine to get input from key 3
Collect User Input 2
Run Macro If Cell have "x" value 0
How do I get an Excel macro to run completely using the keyboard? 5
Runaway Macros! 3
Multiply selected cell by a input form 1

Back
Top