ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Temporarily turning off the keyboard? (https://www.excelbanter.com/excel-programming/353103-temporarily-turning-off-keyboard.html)

Alfredo

Temporarily turning off the keyboard?
 
Is it possible to temporarily turn off the keyboard, i.e. similar to how you
can do with screen updating:

Application.ScreenUpdating = False
Application.ScreenUpdating = True


Thanks in advance



Tom Ogilvy

Temporarily turning off the keyboard?
 
See help on Application.Interactive

--
Regards,
Tom Ogilvy


"alfredo" wrote in message
...
Is it possible to temporarily turn off the keyboard, i.e. similar to how

you
can do with screen updating:

Application.ScreenUpdating = False
Application.ScreenUpdating = True


Thanks in advance





Jim Thomlinson[_5_]

Temporarily turning off the keyboard?
 
Make sure you have bullet proof error handling if you are going to head down
this road. If you change these setting and thing crash and don't get properly
reset, your users will be most upset...
--
HTH...

Jim Thomlinson


"Tom Ogilvy" wrote:

See help on Application.Interactive

--
Regards,
Tom Ogilvy


"alfredo" wrote in message
...
Is it possible to temporarily turn off the keyboard, i.e. similar to how

you
can do with screen updating:

Application.ScreenUpdating = False
Application.ScreenUpdating = True


Thanks in advance






Alfredo

Temporarily turning off the keyboard?
 
Tom, thanks for answer!

Jim, thanks for the warning!!!!!



"Jim Thomlinson" wrote:

Make sure you have bullet proof error handling if you are going to head down
this road. If you change these setting and thing crash and don't get properly
reset, your users will be most upset...
--
HTH...

Jim Thomlinson


"Tom Ogilvy" wrote:

See help on Application.Interactive

--
Regards,
Tom Ogilvy


"alfredo" wrote in message
...
Is it possible to temporarily turn off the keyboard, i.e. similar to how

you
can do with screen updating:

Application.ScreenUpdating = False
Application.ScreenUpdating = True


Thanks in advance






JMB

Temporarily turning off the keyboard?
 
your users will be most upset...

I'm sure they'll understand <g


"Jim Thomlinson" wrote:

Make sure you have bullet proof error handling if you are going to head down
this road. If you change these setting and thing crash and don't get properly
reset, your users will be most upset...
--
HTH...

Jim Thomlinson


"Tom Ogilvy" wrote:

See help on Application.Interactive

--
Regards,
Tom Ogilvy


"alfredo" wrote in message
...
Is it possible to temporarily turn off the keyboard, i.e. similar to how

you
can do with screen updating:

Application.ScreenUpdating = False
Application.ScreenUpdating = True


Thanks in advance







All times are GMT +1. The time now is 12:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com