I have these OnKey initiation commands in an Aut
pen() routine:
Application.OnKey "~", "Check_Key" 'place Enter Key under control of
Application.OnKey "{ENTER}", "Check_Key"
Application.OnKey "{TAB}", "Check_Key"
I have these OnKey termination commands in an Auto_Close routine:
Application.OnKey "~", "" 'Enter Key back to normal
Application.OnKey "{ENTER}", "" 'Numeric Keypad Enter Key
Application.OnKey "{TAB}", ""
Problem: Once I close the spreadsheet containing the above, my enter and Tab keys stop functioning in other spreadsheets until I shutdown Excel and bring it back up.
Any ideas?
Thanks, Jim..

Application.OnKey "~", "Check_Key" 'place Enter Key under control of
Application.OnKey "{ENTER}", "Check_Key"
Application.OnKey "{TAB}", "Check_Key"
I have these OnKey termination commands in an Auto_Close routine:
Application.OnKey "~", "" 'Enter Key back to normal
Application.OnKey "{ENTER}", "" 'Numeric Keypad Enter Key
Application.OnKey "{TAB}", ""
Problem: Once I close the spreadsheet containing the above, my enter and Tab keys stop functioning in other spreadsheets until I shutdown Excel and bring it back up.
Any ideas?
Thanks, Jim..