Trouble with a keyboard shortcut

[baileys2]

I am helping a coworker that is having a strange issue in Excel.

A row of data from an old spreadsheet has somehow been copied, an
every time she hit the "3" key, while in a new or any existing Exce
worksheet, this copied row from the first worksheet is inserted o
pasted into the cell on the active spreadsheet. It happens over an
over again. It's almost like she has unknowingly set up a macro to cu
and paste this certain row but when we checked her macro box, there ar
no macros listed.

Any ideas on what happened here and how we can get it to stop? Thanks

 

[Dave Peterson]

She could have a macro that's tied to that keystroke.

If she opens excel in safe mode:

close excel
windows start button|run
excel /safe
file|open your workbook

and test it out.

If hitting 3 works normally, then I'd bet there was a macro running.

Close excel and reopen it normally.

Open the workbook that has the trouble

Then hit alt-f11 to get to the VBE (where macros live)
hit ctrl-r to see the project explorer.

look through each project and each module and each worksheet module looking for
code.

You could try killing it (may be just a temporary fix), you could use:

hit alt-f11 (to get the vbe)
hit ctrl-g (to see the immediate window)

type this and hit enter:
application.onkey "3"

But depending on how that macro was set up, it could be just a temporary fix.