It takes 12 seconds.

Why so long? OK. The macro takes one of a sequence of data strings from
one sheet, pastes it to a second sheet where the string is processed by
predictive algorithms and cell formulae, the results of which are
logged into a third sheet. The macro then returns to the first sheet to
collect the next data string.There are hundreds of data strings, each
containing hundreds of data points.

While all this is happening, I don't want it to be interrupted by
external inputs, nor do I want anything changed (either deliberately or
by mistake).

On the other hand, as I may need to edit something, I don't want to
lock myself out (which happens if I use "Application.Interactive =
False/True" and hit "Esc" during macro operation).

Both the Sheet Hide and the Sheet Protect methods have to be unhided
and unprotected for the macro to be allowed to modify the sheets.
Perhaps what I need is a means of requiring a password when any key is
pressed during macro operation, but which allows the macro to continue
unless the password is correct.

Am I asking too much??

Astrikor


--
astrikor
------------------------------------------------------------------------
astrikor's Profile: http://www.excelforum.com/member.php...o&userid=31465
View this thread: http://www.excelforum.com/showthread...hreadid=517763