Num Lock gets off when opening the workbook

Hi there!

I've just added the following code to my workbook

Please Login or Register  to view this content.

and when I open it, the num lock turns off. Any idea why?

I added that to a blank workbook and tried and my numlock stays on - I'd suggest uploading an example workbook which demostrates the behaviour to check it isn't something else other than that code?

Edit: looking at google, it seems executing multiple sendkeys statements can turn numlock off (as a bug) - what is the macro supposed to do - maybe is there a way to do it without sendkeys?

I've seen send keys do this before.

Try commenting out

Please Login or Register  to view this content.

saving and then re-opening.

Originally Posted by Solus Rankin

I've seen send keys do this before.

Try commenting out

Please Login or Register  to view this content.

saving and then re-opening.

I didn't get it Solus !
What should I do here?

Edit:
I got it!
I've made a comment in the line, I've saved it, reopend it, and still turns off the Num Lock.

I am not a big fan of Sendkeys(). Even so, sometimes it will have to do.

I had thought of using API routine to check and set the numlock key status as well.

Here is an API method for a sendkeys sort of method. The advantage is that UAC status does not affect this method.

Please Login or Register  to view this content.

Put this in a Module.

Please Login or Register  to view this content.

For kicks, here two methods that I use for toggle keys like numlock.

Please Login or Register  to view this content.

Please Login or Register  to view this content.