Temporarily turning off the keyboard?

[alfredo]

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]

See help on Application.Interactive

--
Regards,
Tom Ogilvy


"alfredo" <[email protected]> wrote in message
news:[email protected]...
> 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]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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]

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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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]

> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> > >
> > >
> >
> >
> >