I am running a routine from excel vba that calls some other non excel
apps, some are non-windows ones in terminal emulators, and if anyone
does any keystrokes etc while the whole thing is running it really
messes up. I've found some things which will disable the keyboard
just for the excel/vba app, but this is not enough as focus passes to
the other programs for a while, and i need to keep the keyboard turned
off while this is the case. I realise that this could be a dangerous
thing to do so don't want to mess with registry stuff, just do it in
VBA so that if something does go wrong i can always hit the power
plug. Something that looked like
Sub Main()
Keyboard.disable
call first-app
call next sub
shell another.bat
keyboard.enable (or keyboard.disable = false)
end sub

any suggestions please?