Ctrl+X messed up

[James Fonda]

This is driving me nuts! I've put up with it for months and can't find the
answer. When I try to use Ctrl+X instead of cutting it automatically grabs
the data in the cell and throws it over into a cell a couple of columns
away. What in the world is wrong with this thing?

 

[A.W.J. Ales]

James,

Maybe not much of a help, but the only thing I can come up with is that
somehow a macro is attached to the control+X combination

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Dave Peterson]

Just to add to AJW's response.

You can verify that it is a macro by starting excel in safe mode and testing it
out.

close excel
windows start button
run
excel /safe
ok

Then try your ctrl-x combination.

(It sure sounds like a helpful macro to me, too.)

Then next thing you'll have to do is find that macro.

Close excel and reopen it normally.

You'll want to find out if it loads each time excel starts up or if it's
associated with a specific workbook.

So you can try the ctrl-x stuff without loading any workbook to see if it's
already waiting for you.

If it is, then I'd bet that that code is either in an addin (Tools|Addins, one
of those checked items) or in a workbook in your XLStart folder.

You can turn off all the addins, then close excel and remove everything from
your XLStart folder.

Now start adding things back one at a time and restarting excel. When you find
the culprit, you'll have to decide if it's important enough to keep (or if you
can change/fix it).

=====

One more spot to look:

Tools|Options|General Tab:
"at startup, open all files in:" <xl2002 wording>
"Alternate Startup File location" <before xl2002 wording>

Clear out that box. (I've never seen anyone really use this.) And some fill it
in by mistake.

Chip Pearson has some additional notes to help diagnose this kind of problem at:
http://www.cpearson.com/excel/StartupErrors.htm

====

If it's not loaded when you startup excel, then load that workbook where you
noticed the problem. Try it again (just in case something else turned it on).
If it worked, go to the developer and tell them to turn it off!

 

[David McRitchie]

might be easier to just assign ctrl+x to a new throwaway macro
and then delete the macro.

 

[Dave Peterson]

That didn't work for me.

I put this in book1:
Option Explicit
Sub throwaway1()
MsgBox "throwaway1"
End Sub

And did tools|macro|options and assigned ctrl-x to throwaway1.

The I put this in book2:
Option Explicit
Sub throwaway2()
MsgBox "throwaway2"
End Sub

And assigned it to ctrl-x.

Back to excel and hit ctrl-x.
Up popped the throwaway1 message.
(from book1, book2 and book3)

I closed book2 and tried it, still got throwaway1.

I ran this to try to reset ctrl-x:
Sub resetctrlx()
Application.OnKey "^x"
End Sub

I still got throwaway1.

I could run this:
Sub killctrlx()
Application.OnKey "^x", ""
End Sub

And it did disable ctrl-x completely (no cut and no macro).

I tried resetting Edit|Cut (via tools|Customize and rightclicking on Cut under
Edit and clicking reset--it didn't work either).

I was stumped except for contacting the developer or killing it completely.

I tested with xl2002.


But

 

[James Fonda]

You guys are awesome, it's fixed!!!
It was a macro in a workbook. I just went through them and found the culprit
then deleted the one that was causing trouble.
Thanks!!!

 

[Dave Peterson]

You may have wanted to keep the macro, but eliminate the shortcut?????

(either way, glad you're happy)

You guys are awesome, it's fixed!!!
It was a macro in a workbook. I just went through them and found the culprit
then deleted the one that was causing trouble.
Thanks!!!