View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jezebel
 
Posts: n/a
Default 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?