HOW CAN I STOP MACRO FROM SHUTTING OFF NUMERIC LOCK?

  • Thread starter MACRO SHUTTING OFF NUMERIC LOCK
  • Start date
M

MACRO 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?
 
B

Bob Phillips

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