View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
snax500[_2_] snax500[_2_] is offline
external usenet poster
 
Posts: 29
Default navigation keys are turning off

In Excel2000, I have the following (see below) macro to add apostrophes
to a selected range. After running the macro, my arrow (navigation)
keys stop working. If I then go to another file they stert up again. I
DO NOT have any Transistion keys enabled. Any ideas on how I can fix
this?

Thanks

Sub add_appostraphe()
Dim myinput

On Error GoTo finit

Set myinput = Application.InputBox(prompt:="Select a range that needs
an apostrophe", Type:=8)

For Each cll In myinput
n = cll.Value
cll.Value = "'" & n

Next

finit:
End Sub