HOW CAN I STOP MACRO FROM SHUTTING OFF NUMERIC LOCK?
 

I AM RUNNING A MACRO AT THE END OF DATA ENTRY TO SHIFT COLUMNS AND STORE
ENTERED DATA. THE MUNERIC LOCK ALWAYS SHUTS OFF WHEN MACRO IS FINISHED. HOW
CAN I PREVENT NUMERIC LOCK FROM SHUTTING OFF?

HOW CAN I STOP MACRO FROM SHUTTING OFF NUMERIC LOCK?
 

Remove the instruction in the macro that is changing the numeric lock
setting.



"MACRO SHUTTING OFF NUMERIC LOCK" <MACRO SHUTTING OFF NUMERIC
wrote in message
...
I AM RUNNING A MACRO AT THE END OF DATA ENTRY TO SHIFT COLUMNS AND STORE
ENTERED DATA. THE MUNERIC LOCK ALWAYS SHUTS OFF WHEN MACRO IS FINISHED.
HOW
CAN I PREVENT NUMERIC LOCK FROM SHUTTING OFF?

HOW CAN I STOP MACRO FROM SHUTTING OFF NUMERIC LOCK?
 

You want to turn Caps Lock off as well!

You will probably find a Sendkeys statement turning it off, like

SendKeys "{NUMLOCK}"

If so, remove that lijne of code.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"MACRO SHUTTING OFF NUMERIC LOCK" <MACRO SHUTTING OFF NUMERIC
wrote in message
...
I AM RUNNING A MACRO AT THE END OF DATA ENTRY TO SHIFT COLUMNS AND STORE
ENTERED DATA. THE MUNERIC LOCK ALWAYS SHUTS OFF WHEN MACRO IS FINISHED.
HOW
CAN I PREVENT NUMERIC LOCK FROM SHUTTING OFF?