Take a look at application.EnableCancelKey in VBA's help.

astrikor wrote:

astrikor Wrote:
Thanks funkymonkUK - that it exactly - and your solution works great.
I now have the whole thing password protected, (macros and worksheets)
from interference, with the automacro unhiding and hiding the
worksheets as part of its runtime code.

Many thanks. Astrikor

Sorry guys,

It all falls apart when I hit "Esc" while the macro is running - the
macro stops revealing the "hidden" worksheets. This is surprising
because it overrides a previous Application.ScreenUpdating = False
command which normally holds the starting worksheet sheet on the
screen.

It looks as if i need a command to request a password so that when any
keyboard key is pressed while the macro is running NOTHING can change
until password enabled.

Any ideas?
Thanks
Astrikor

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

--

Dave Peterson