onkey action error

[Talorthain]

Hi,

I set onkey in a worksheet.activate procedure;

application.onkey "{F2}", "Edit_Cell"

The onkey is removed under the worksheet.deactivate.

The procedure "Edit_Cell" is in the same workbook and works correctly. (Allows a user to edit a cell in a protected sheet, without losing the contents)

When the users presses 'F2' in the worksheet, excel tries to re-open the workbook and doesnt just call the procedure.

Is there any reason excel would attempt to find the procedure in another copy of the same workbook?

[nathansav]

Ive just ran it on mine and it works fine. can you attach?

[Talorthain]

Hi, Thank you for the quick response. Unfortunately the file is commercially sensitive so I cant send in a completed form. I might be able to strip out the single element.

I have used the onkey command many times, in many excel tools that I have developed, but I have not seen excel do this before!! The work computers have recently been upgraded to Win7 and Bit locker, which does from time to time have strange affects.

Is there any common or known reason, for the behaviour, where excel tries to call the function in a new copy of the same file?