Ctrl + V & Ctrl + S & Ctrl + X etc. etc.

[ReneBC3]

Hi.

I have a (for me) serious problem. I have just been upgraded from Office
2003 to Office 2007 at work!

For some reason all of my Ctrl + "shortcut key" doesn't work anymore (

Evertime I try to use a Ctrl + "shortcut key" function I get a message
saying "No cells were found" (translated from danish).

I have looked in settings to see if I can change it there to get my shortcut
keys back, but unfortunately I had no luck (

Does anyone have any idea what to do??

I am getting quite frustrated here. I have to copy/paste more than 3000
individual addresses, and I think I'll go nuts if I have to right click the
spreadsheet everytime to paste into the sheet instead of using Ctrl + V

 

[Zone]

Rene, I cannot believe Excel 2007 would steal these time-honored shortcut
keys to do something different. Does the problem occur in one of your own
workbooks? Any Excel 2007 users have any comments on this? I use Excel
2003 and I AIN'T GIVING UP these shortcuts to get 2007. Of course, you
could create subroutines to emulate the functionality of the stolen shortcut
keys, but that could get messy if it's happening on all your workbooks.
James

 

[Peo Sjoblom]

The shortcuts are the same in 2007 as in 2003, including the stupid change
that was made to Ctrl + A where in 2002 and previous versions it selects the
whole worksheet but in 2003 and 2007 it selects the current region on the
first key press and the whole sheet on the next key press.

 

[Zone]

Good info, Peo. I suspect Rene has some macros in the workbook she's using
that are grabbing those shortcuts. I got a reply about using onkey to
disable those shortcuts, but surely that resets after the workbook closes.
http://www.vbaexpress.com/kb/getarticle.php?kb_id=373
James