ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Ron DeBruin's "Enable_Keys" program (https://www.excelbanter.com/excel-programming/419294-ron-debruins-enable_keys-program.html)

XP

Ron DeBruin's "Enable_Keys" program
 
Using Office 2007 and Win XP;

I'm using code from Ron De Bruin's page in which key combinations are first
disabled then enabled using "Enable_Keys" program at:

http://www.rondebruin.nl/key.htm

This program runs fine when I run it stand alone; but when I call it from
another module, if blows up in the section I've copied below:

For lX = 1 To 255 'enable key combinations with all other keys
Application.OnKey vKeyCombo & Chr$(lX)
Next lX

However, I find that there are certain values it hangs on, so far if I've
identified the following values: 0, 37, 40, 41, 42, 43, 91, 93, 94, 123,
125, 128, 129, 130, 131, 132, 133...

This is not complete as I am still testing, but does anyone know what is
going on here? Why does it run okay stand alone, but not okay when called
from another module?

Thanks in advance...

XP

Ron DeBruin's "Enable_Keys" program
 

Sorry, I forgot to mention that the key combination issue occurs with the
plus (+) sign only...

"XP" wrote:

Using Office 2007 and Win XP;

I'm using code from Ron De Bruin's page in which key combinations are first
disabled then enabled using "Enable_Keys" program at:

http://www.rondebruin.nl/key.htm

This program runs fine when I run it stand alone; but when I call it from
another module, if blows up in the section I've copied below:

For lX = 1 To 255 'enable key combinations with all other keys
Application.OnKey vKeyCombo & Chr$(lX)
Next lX

However, I find that there are certain values it hangs on, so far if I've
identified the following values: 0, 37, 40, 41, 42, 43, 91, 93, 94, 123,
125, 128, 129, 130, 131, 132, 133...

This is not complete as I am still testing, but does anyone know what is
going on here? Why does it run okay stand alone, but not okay when called
from another module?

Thanks in advance...


Ron de Bruin

Ron DeBruin's "Enable_Keys" program
 
Hi XP+

If I call the code from my site from another module I have no problem

I see you have changed the code so maybe there is a error in your code

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"XP" wrote in message ...
Using Office 2007 and Win XP;

I'm using code from Ron De Bruin's page in which key combinations are first
disabled then enabled using "Enable_Keys" program at:

http://www.rondebruin.nl/key.htm

This program runs fine when I run it stand alone; but when I call it from
another module, if blows up in the section I've copied below:

For lX = 1 To 255 'enable key combinations with all other keys
Application.OnKey vKeyCombo & Chr$(lX)
Next lX

However, I find that there are certain values it hangs on, so far if I've
identified the following values: 0, 37, 40, 41, 42, 43, 91, 93, 94, 123,
125, 128, 129, 130, 131, 132, 133...

This is not complete as I am still testing, but does anyone know what is
going on here? Why does it run okay stand alone, but not okay when called
from another module?

Thanks in advance...



All times are GMT +1. The time now is 05:21 AM.

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