Macro to only Cut and Paste

  • Thread starter Thread starter GCRDelphi
  • Start date Start date
G

GCRDelphi

I Want to create a code in the Worksheet_change condition, that will verify
that only Cut and Paste is allowed. For example a when a change is made to
verify that it's a Cut and Paste action and anything else is canceled or
undone.

Thank you for your help.
 
I think you are looking at a protected worksheet with a button that has code
to unprotect the sheet, cut the user's selection which sparks a sheet cnange
event with a message to select a cell for pasting the data. then the paste
action could trigger code to reset the protection. Could be a little tricky,
bu doable. I don't believe that disabling everything on the menu bar except
cut and paste would work since that does no affect the pop up menus. But it
is only an opinion.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top