View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Charles Chickering Charles Chickering is offline
external usenet poster
 
Posts: 272
Default Substitute copy for cut

You really should educate your users rather than screwing with their pcs. You
can place a macro in your workbook and use Ctl + x as the shortcut to it,
with this line of code for the macro to run:
Selection.Copy
that will prevent the keyboard shortcut.
--
Charles Chickering

"A good example is twice the value of good advice."


"KS" wrote:

I have some users that cannot figure out difference between copy and
cut. They are always cutting when they should be copying. How can I
write a code that anytime, anyway they choose cut it will automatically
change it to a copy? They are basically selection some cells in a
worksheet & cutting them somewhere else in the worksheet. What they are
doing is simple but how can I override their keystrokes to be the
correct one?

Thanks for any help.

KS