| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
| Highlight Range - wrong macro, please edit. | Excel Worksheet Functions | |||
| stop macro from flashing sheets | Excel Discussion (Misc queries) | |||
| AVERAGE Row of Numbers and Return Corresponding Numeric Label | Excel Worksheet Functions | |||
| How do I stop macro alerts for a spreadsheet with no macros in it | Excel Discussion (Misc queries) | |||
Linear Mode
