Office Prank Victim

[Scott C]

Somebody in my office played a prank on me via Excel, and
I don't want to give them the satisfaction of asking how
to remove it. When I ctrl+C and ctrl+V to copy and paste,
windows with insulting messages pop up. I checked my
macros and there wasn't anything there that shouldn't be,
but my knowledge of that stuff is pretty much limited to
recording things into the personal workbook. Please help!

Scott

 

[Earl Kiosterud]

Scott,

Here's the strategy. Try Ctrl-Insert instead of Ctrl-C for copy.
Shift-Insert for paste. They're old shortcuts, but still seem to work. If
they work normally, act as if nothing is wrong. Smoke out the culprit.

Be sure to look in all the modules of every project you see in the Project
Explorer in the VBE.

 

[Bob Phillips]

Also, in the VBE imm ediate window enter this

Application.OnKey "^(C)", ""

Application.OnKey "^(V)", ""

to reset them


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

I tried that, but got the following error message:

Run Time Error '1004':
Application-defined or object-defined error

 

[Dave Peterson]

Try it without the ()'s:

Application.OnKey "^C", ""
Application.OnKey "^V", ""