Application.OnKey

[Kevin H. Stecyk]

Hi,

If I set Application.OnKey during opening of the workbook:

Application.OnKey "+^T", "DoMyStuff"

I suspect that I should somehow cancel it when the workbook closes. How do
I accomplish that?

Your guidance is appreciated.

Regards,
Kevin

[richardreye]

To cancel your onkey add this line of code

Application.OnKey "+^T"

Cheers!

[Norman Jones]

Hi Kevin,

Try:

Application.OnKey "+^T", ""


---
Regards,
Norman



"Kevin H. Stecyk" <[email protected]> wrote in message
news:%[email protected]...
> Hi,
>
> If I set Application.OnKey during opening of the workbook:
>
> Application.OnKey "+^T", "DoMyStuff"
>
> I suspect that I should somehow cancel it when the workbook closes. How
> do I accomplish that?
>
> Your guidance is appreciated.
>
> Regards,
> Kevin
>