Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you change navigation keys?? | Excel Discussion (Misc queries) | |||
Transition navigation keys | Excel Discussion (Misc queries) | |||
navigation keys in protected sheet | Excel Discussion (Misc queries) | |||
Transition Navigation Keys | Excel Discussion (Misc queries) | |||
Using Navigation Keys | Excel Programming |